java 在 DB2 中插入期间 SQLCODE=-723
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/7554098/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
SQLCODE=-723 during insertions in DB2
提问by Sripaul
I have a series of insert statements in my code. The table has few triggers to update last updated date and time.
我的代码中有一系列插入语句。该表几乎没有触发器来更新上次更新的日期和时间。
Certain insertions are succeeding while other similar inserts into the table fails with DB2 SQL Error: SQLCODE=-723, SQLSTATE=09000, SQLERRMC=CMSDB.ITNPROD_AUDIT_AFTER_INSERT;-818;51003;, DRIVER=4.8.87
某些插入成功，而其他类似的表插入失败并显示 DB2 SQL 错误：SQLCODE=-723, SQLSTATE=09000, SQLERRMC=CMSDB.ITNPROD_AUDIT_AFTER_INSERT;-818;51003;, DRIVER=4.8.87
What could be the problem. My worry is it works for certain records whereas fails for other.
可能是什么问题呢。我担心的是它对某些记录有效，而对其他记录无效。
回答by Michael Sharek
Look up the errors in the DB2 Message reference.
在 DB2 Message 参考中查找错误。
The SQL0723N error (here) is telling us that an error occurred in the named trigger (in your case, the trigger is named CMSDB.ITNPROD_AUDIT_AFTER_INSERT).
SQL0723N 错误（此处）告诉我们命名触发器中发生错误（在您的情况下，触发器名为 CMSDB.ITNPROD_AUDIT_AFTER_INSERT）。
Furthermore, in the second part of the message, DB2 is telling us that the error that is occurring in the trigger is SQL0818N (SQLSTATE 51003) which is here.
此外，在消息的第二部分，DB2 告诉我们触发器中发生的错误是 SQL0818N (SQLSTATE 51003)，它在这里。
I don't really understand what 818 is saying, but it seems you may have some sort of timestamp problem with a package. Good luck.
我不太明白 818 在说什么，但看起来你的包可能有某种时间戳问题。祝你好运。
