sqlcode: -530

字数 1474阅读 1785评论 0赞 0

db2 ? sql530 SQL0530N  The insert or update value of the FOREIGN KEY       "<constraint-name>" is not equal to any value of the parent key of       the parent table. Explanation: A value in a foreign key of the object table is being set, but this value is not equal to any value of the parent key of the parent table. When a row is inserted into a dependent table, the insert value of a foreign key must be equal to some value of the parent key of any row of the parent table of the associated relationship. Similarly, when the value of a foreign key is updated, the update value of a foreign key must be equal to the value of the parent key of any row of the parent table of the associated relationship at the completion of the statement. Federated system users: the constraint can exist on the data source (if the child and parent tables exist on the data source). Some data sources do not provide the appropriate values for "<constraint name>". In these cases the message token will have the following format: "<data source>:UNKNOWN", indicating that the actual value for the specified data source is unknown. The statement could not be executed. The contents of the object table are unchanged. User response: Examine the insert or update value of the foreign key first, and then compare it with each of the parent key values of the parent table to determine and correct the problem.  sqlcode: -530  sqlstate: 23503

数据库 update insert

著作权归作者所有

如果觉得我的文章对您有用，请点赞。您的支持将鼓励我继续创作！

添加新评论0 条评论

Ctrl+Enter 发表

匿名评论

sqlcode: -530

添加新评论0 条评论

作者其他文章

相关文章

相关问题

相关资料