Listing 13 demonstrates how a specific error can transfer control to the exit handler where a user-defined error message is returned depending on the value of the SQLCODE.
清单13展示了一个特定的错误如何将控制转移给退出处理程序,其中根据SQLCODE的值返回用户定义的错误消息。
It is a common practice to copy the values of SQLSTATE and SQLCODE into local variables in the first statement of the handler, as shown in Listing 11.
将SQLSTATE和SQLCODE的值复制到处理程序的第一个语句的本地变量中,这是一种常见的做法,如清单11所示。
Error handling: the new stored procedure now returns SQLCA with proper SQLCODE and SQLSTATE that is more inline with the error handling framework when using SQL.
错误处理:新的存储过程现在返回带有适当SQLCODE和SQLSTATE的SQLCA,在使用SQL时与错误处理框架更加内联。
However, the security administrator cannot transfer an object to himself or herself, otherwise sqlcode -20379 is returned.
但是安全管理员不能将对象转移给他或她自己,否则会返回sqlcode - 20379。
The next phase of the JCC product is to define these error codes with an SQLSTATE and SQLCODE.
下一阶段的JCC产品将用SQLSTATE和SQLCODE来定义这些错误代码。
The next phase of the JCC product is to define these error codes with an SQLSTATE and SQLCODE.
下一阶段的JCC产品将用SQLSTATE和SQLCODE来定义这些错误代码。
应用推荐