外部约束DB2 UDB v8.1.7 Linux [英] Foreign constraints DB2 UDB v8.1.7 Linux
问题描述
为什么以下约束无效?我想确保IS3.ANIMALS_PRIV_INDEXES中的每一行
行与
IS3.table_var_defn中的一行匹配,其中部分主键已修复。由于这是非法的b / b非法使用以下消息,我该如何实现这个结果?
下面的最后一项是来自另一个表的工作约束。
ALTER TABLE IS3.ANIMALS_PRIV_INDEXES
ADD CONSTRAINT >
FOREIGN KEY(3,variable_id)
REFERENCES IS3.table_var_defn(table_id,variable_id)
ON DELETE NO ACTION
ON更新无操作
DB2 SQL错误:SQLCODE:-104,SQLSTATE:42601,SQLERRMC:FOREIGN KEY; ADD
CONSTRAINT; NUMERIC
消息:意外的令牌FOREIGN KEY在ADD
CONSTRAINT之后被发现。预期的代币可能包括:NUMERIC。
ALTER TABLE IS3.ANIMALS_PRIV_LABELS
ADD CONSTRAINT
FOREIGN KEY(table_id, variable_id)
REFERENCES参考IS3.table_var_defn(table_id,variable_id)
ON DELETE NO ACTION
ON更新无动作
Why is the following constraint invalid? I want to make sure that every
row in IS3.ANIMALS_PRIV_INDEXES matches one of those in
IS3.table_var_defn with part of the primary key fixed. Since this is
illegal with the following message, how do I achieve this result? The
last thing below is a working constraint from another table.
ALTER TABLE IS3.ANIMALS_PRIV_INDEXES
ADD CONSTRAINT
FOREIGN KEY(3, variable_id)
REFERENCES IS3.table_var_defn(table_id, variable_id)
ON DELETE NO ACTION
ON UPDATE NO ACTION
DB2 SQL error: SQLCODE: -104, SQLSTATE: 42601, SQLERRMC: FOREIGN KEY;ADD
CONSTRAINT;NUMERIC
Message: An unexpected token "FOREIGN KEY" was found following "ADD
CONSTRAINT". Expected tokens may include: "NUMERIC".
ALTER TABLE IS3.ANIMALS_PRIV_LABELS
ADD CONSTRAINT
FOREIGN KEY(table_id, variable_id)
REFERENCES IS3.table_var_defn(table_id, variable_id)
ON DELETE NO ACTION
ON UPDATE NO ACTION
推荐答案
" Bob Stearns" < RS ********** @ charter.net>在消息中写道
新闻:Nq ***************** @ fe03.lga ...
"Bob Stearns" <rs**********@charter.net> wrote in message
news:Nq*****************@fe03.lga...
为什么以下约束无效?我想确保IS3.ANIMALS_PRIV_INDEXES中的每一行与IS3.table_var_defn
中的一行匹配,其中部分主键已修复。由于这是非法的
以下消息,我该如何实现这一结果?下面的最后一项是来自另一个表的
工作约束。
ALTER TABLE IS3.ANIMALS_PRIV_INDEXES
添加约束
外键(3,variable_id)
参考IS3.table_var_defn(table_id,variable_id)
ON DELETE NO ACTION
ON UPDATE NO ACTION
Why is the following constraint invalid? I want to make sure that every
row in IS3.ANIMALS_PRIV_INDEXES matches one of those in IS3.table_var_defn
with part of the primary key fixed. Since this is illegal with the
following message, how do I achieve this result? The last thing below is a
working constraint from another table.
ALTER TABLE IS3.ANIMALS_PRIV_INDEXES
ADD CONSTRAINT
FOREIGN KEY(3, variable_id)
REFERENCES IS3.table_var_defn(table_id, variable_id)
ON DELETE NO ACTION
ON UPDATE NO ACTION
ALTER TABLE IS3.ANIMALS_PRIV_INDEXES
添加约束
FOREIGN KEY(table_id,variable_id)
REFERENCES IS3.table_var_defn(table_id,variable_id)
ON DELETE NO ACTION
ON更新无动作
ALTER TABLE IS3.ANIMALS_PRIV_INDEXES
ADD CONSTRAINT
FOREIGN KEY(table_id, variable_id)
REFERENCES IS3.table_var_defn(table_id, variable_id)
ON DELETE NO ACTION
ON UPDATE NO ACTION
添加约束名称:
ALTER TABLE IS3.ANIMALS_PRIV_LABELS
ADD CONSTRAINT xxxxxx
FOREIGN KEY(table_id,variable_id)
REFERENCES IS3.table_var_defn(table_id,variable_id)
ON DELETE NO ACTION
ON更新无动作
Add constraint name:
ALTER TABLE IS3.ANIMALS_PRIV_LABELS
ADD CONSTRAINT xxxxxx
FOREIGN KEY(table_id, variable_id)
REFERENCES IS3.table_var_defn(table_id, variable_id)
ON DELETE NO ACTION
ON UPDATE NO ACTION
对不起。我在你的帖子中引用了不同的ALTER语句。
我认为你的ALTER语句有两个问题。
1)在CONSTRAINT关键字后需要使用constraint-name。
虽然,你写了
I''m sorry. I referenced different ALTER statement in your post.
I think your ALTER statement have two problem.
1) constraint-name is required after CONSTRAINT keyword.
Though, you wrote
下面的最后一件事是来自另一个表的工作约束。
The last thing below is a working constraint from another table.
但是,在我的Windows上的DB2 UDB V8 FP9a中,我收到了以下消息,如果没有指定
约束名称。
SQL0104N意外的令牌FOREIGN KEY被发现在loyee
ADD CONSTRAINT之后。预期的令牌可能包括:< col_type>。
SQLSTATE = 42601
2)FOREIGN KEY只能指定列名。你指定了
常数3.
ALTER TABLE IS3.ANIMALS_PRIV_INDEXES
ADD CONSTRAINT< constraint-name>
FOREIGN KEY(< column-name>,variable_id)
REFERENCES IS3.table_var_defn(table_id,variable_id)
ON DELETE NO ACTION
ON更新无动作
But, in my DB2 UDB V8 FP9a on Windows, I got following message, if no
constraint-name was specified.
SQL0104N An unexpected token "FOREIGN KEY" was found following "loyee
ADD CONSTRAINT". Expected tokens may include: "<col_type>".
SQLSTATE=42601
2) FOREIGN KEY can be specified only column name. You specified
constant number 3.
ALTER TABLE IS3.ANIMALS_PRIV_INDEXES
ADD CONSTRAINT <constraint-name>
FOREIGN KEY(<column-name>, variable_id)
REFERENCES IS3.table_var_defn(table_id, variable_id)
ON DELETE NO ACTION
ON UPDATE NO ACTION
这篇关于外部约束DB2 UDB v8.1.7 Linux的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!