One CONNECT with a +100 SQLCODE returned for row 26
一个CONNECT ，以及 100 个以上针对第 26行返回的SQLCODE
Listing 3 shows an example of our first error, sqlcode SQL4301 with return code 0.
清单3显示第一个错误的例子，sqlcode为sql 4301，返回码为0。
The next phase of the JCC product is to define these error codes with an SQLSTATE and SQLCODE.
下一阶段的JCC产品将用SQLSTATE和SQLCODE来定义这些错误代码。
To use the SQLCODE and SQLSTATE values, you must declare these variables as shown in Listing 10.
要使用SQLCODE和sqlstate值，就必须像清单10那样声明这些变量。
If you do not set the status, DB2 sets the status to 0 or -1, depending on the value of the SQLCODE.
如果没有设置状态，DB 2将根据SQLCODE的值将状态设置为0或- 1。
All tables that reside in the group are redistributed if the command succeeds and returns sqlcode 0.
如果命令成功，并返回sqlcode0，则组中所有的表都被重分发。
The errstr method returns a message for an SQLCODE associated with a Perl DBI database handle or statement handle.
errstr方法返回与某个PerlDBI数据库句柄或语句句柄相关的SQLCODE的消息。
However, the security administrator cannot transfer an object to himself or herself, otherwise sqlcode -20379 is returned.
但是安全管理员不能将对象转移给他或她自己，否则会返回sqlcode - 20379。
In order to return the SQLCODE associated with a Perl DBI database handle or statement handle, you can call the err method.
为了返回与某个PerlDBI数据库句柄或语句句柄相关的SQLCODE，可以调用err方法。
A transaction lock conflict could either lead to rolling back a transaction (sqlcode -911), or to waiting indefinitely for the lock.
事务锁冲突可以导致事务回滚(sqlcode - 911)，或者导致不确定地等待锁。
If there are more tables to redistribute, but the redistribute was stopped due to the stop AT time constraint, the command returns sqlcode + 1379.
如果有更多的表要重分发，但是由于STOPAT时间限制重分发被停止，那么该命令返回sqlcode + 1379。
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所示。
However, if the SQLCODE and SQLSTATE variables have been declared, they will contain the corresponding values for the condition, and you can check them.
然而，如果SQLCODE和SQLSTATE变量都已被声明，那么它们将为语句包含相应的值，并且可以检查这些值。
If the SQLSTATE and SQLCODE variables have been declared, their values will be reset to 00000 and 0 respectively after successful execution of the handler.
如果已经声明了SQLSTATE和SQLCODE变量，那么在成功执行处理程序后，它们的值将被分别重置为00000和0。
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时与错误处理框架更加内联。
First of all, the checking for a NOT FOUND warning can be done explicitly, if so desired, without having to save away the SQLCODE and SQLSTATE into local variables.
首先，可以显式地检查NOTFOUND警告(如果想这样做的话)，而不必在局部变量中保存SQLCODE和SQLSTATE。
It does not matter if more than 200 rows would have qualified; DB2 will signal end of data with a + 100 SQLCODE if you try to FETCH more than 200 rows from the query.
如果有超过200行符合条件也没有关系；如果您尝试从查询中FETCH(访存)超过200行，DB 2将用+ 100SQLCODE表明数据结束。
If a statement raises a condition for which a handler exists, the values of the SQLSTATE and SQLCODE variables are available at the beginning of the handler execution.
如果某条语句发出一个存在处理程序的条件，那么SQLSTATE和SQLCODE变量的值就可以在开始执行处理程序时获得。
For both databases you can declare error handlers that will determine what action are taken if an SQL statement fails with a particular error code (SQLCODE or SQLSTATE).
对于这两种平台上的数据库，您都可以声明错误处理程序，如果带有特殊的错误代码(SQLCODE或SQLSTATE)的sql语句失败，那么该处理程序将判定应采取哪些措施。
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的值返回用户定义的错误消息。
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的值返回用户定义的错误消息。
应用推荐