aiaiDBA

加微信获取免费职业规划+学习资料,了解年薪50万的DBA是如何练成的

13718043309

010-86462881

PCB-00554: Must include SQLCA when mode=ANSI and WHENEVER SQLWARNING used

PCB-00554: Must include SQLCA when mode=ANSI and WHENEVER SQLWARNING used
Cause: When MODE={ANSI | ANSI14}, an attempt was made to use the WHENEVER SQLWARNING statement without declaring the SQLCA. When MODE={ANSI | ANSI14}, declaring the SQLCA is optional, but to use the WHENEVER SQLWARNING statement, the SQLCA must be declared.
Action: Remove all WHENEVER SQLWARNING statements from the program or declare the SQLCA by hardcoding it or copying it into the program with the INCLUDE statement.

请先 登录 后评论

1 个回答

小智
PCB-00554:当mode = ANSI和WHENEVER SQLWARNING使用时,必须包含SQLCA,
.原因:当MODE = {ANSI | ANSI14},尝试使用WHENEVER SQLWARNING语句而不声明SQLCA。当MODE = {ANSI | ANSI14},声明SQLCA是可选的,但要使用WHENEVER SQLWARNING语句,必须声明SQLCA。,
.操作:从程序中删除所有WHENEVER SQLWARNING语句,或通过硬编码或通过INCLUDE语句将其复制到程序中来声明SQLCA。,
.
请先 登录 后评论