"No column name" is not allowed. Sqlstate-23502.

“ no column name ”是不允许的。

The table cannot have data capture enabled (SQLSTATE 42997).

表不能启用数据捕捉(SQLSTATE 42997)。

A handler is declared for two specific errors identified by SQLSTATE.

将针对由SQLSTATE标识的两个特定错误声明处理程序。

The data type of an identity column cannot be altered (SQLSTATE 42997).

不能修改标识列的数据类型(SQLSTATE 42997)。

in this situation, a warning will be returned to the user SQLSTATE 01626.

(在此情况下，用户将收到一条警告(SQLSTATE 01626))。

The INSERT error transfers control to the exit handler for that SQLSTATE code.

INSERT 错误将控制转移到 SQLSTATE 代码的退出处理程序。

Check the error messages and the associated SQLSTATE value for diagnosis on the message.

检查错误消息和相关的sqlstate值，以便根据消息做出诊断。

The next phase of the JCC product is to define these error codes with an SQLSTATE and SQLCODE.

下一阶段的JCC产品将用SQLSTATE和SQLCODE来定义这些错误代码。

The new data type must be compatible with the existing data type of the column (SQLSTATE 42837).

新的数据类型必须与列的现有数据类型兼容(SQLSTATE 42837)。

To use the SQLCODE and SQLSTATE values, you must declare these variables as shown in Listing 10.

要使用SQLCODE和sqlstate值，就必须像清单10那样声明这些变量。

Associated text and tokens are "EXECUTE permission denied on object sp_mixtab2, databas". SQLSTATE=560BD

相关文本和标记是 "EXECUTE permission denied on object sp_mixtab2, databas"。

It causes an error or warning to be returned with the specified SQLSTATE, along with optional message text.

它将促使返回一个错误或警告，包含指定的SQLSTATE以及可选的消息文本。

Any valid SQLSTATE value can be used in the SIGNAL statement, including user-defined SQLSTATEs and conditions.

任何有效sqlstate值都可以用于signal语句中，包括用户定义的SQLSTATE和条件。

Return codes and SQLSTATE messages aid in diagnosing error conditions during the execution of an ODBC application.

返回代码和SQLSTATE消息可以帮助诊断odbc应用程序执行期间出现的错误状况。

Altering a column must not make the total byte count of all columns exceed the maximum record size (SQLSTATE 54010).

对列的修改不能导致所有列的总字节数超过记录的最大大小(SQLSTATE 54010)。

Altering this attribute for a column requires table reorganization before further table access is allowed (SQLSTATE 57016).

修改列的这个属性要求进行表重组，然后才允许进行进一步的表访问(SQLSTATE 57016)。

In order to return the SQLSTATE associated with a Perl DBI database handle or statement handle, you can invoke the state method.

为了返回与某个Perl DBI数据库句柄或语句句柄相关的SQLSTATE，可以调用state方法。

If you attempt to alter a table to use this lock size option, and it isn't an MDC table, you will receive an SQLSTATE 628n error.

如果您尝试修改一个表，以便使用这种锁粒度选项，而那个表又不是mdc表，那么您将收到一个SQLSTATE 628n错误。

For each diagnostic record, a SQLGetDiagRec function call retrieves SQLSTATE values, diagnostic messages, and native error codes.

对于每条诊断记录，SQLGetDiagRec函数调用将检索s QL state值、诊断消息和本地错误代码。

This clause is not allowed if the column is specified in the primary key, or in a unique constraint of the table (SQLSTATE 42831).

如果表的主键或惟一性约束中指定了这个列，那么不允许使用这个子句(SQLSTATE 42831)。

SQLSTATE messages give specific information about what caused an error or warning condition, and are very useful for resolving errors.

SQLSTATE消息可以提供关于导致错误或警告状况的原因的特定信息，这对于解决错误很有用。

When Derby shuts down a database, it throws an SQLException with an SQLState of 08006, which is why the catch block ignores this exception.

Derby关闭数据库时，将抛出SQLException，使用08006作为SQLState，这就是catch块忽略此异常的原因。

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所示。

The specified length, precision, or scale can be greater than or equal to (but not less than) the existing length, precision, or scale (SQLSTATE 42837).

指定的长度、精度或刻度可以大于或等于(但是不能小于)现有的长度、精度或刻度(SQLSTATE 42837)。

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。

The "Reorg recommended" column identifies the data type alterations that require table reorganization before a table can again be accessed (SQLSTATE 57016).

“需要重组” 列表示这种数据类型修改是否要求在访问表之前进行表重组（SQLSTATE 57016）。

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.

首先，可以显式地检查NOT FOUND警告(如果想这样做的话)，而不必在局部变量中保存SQLCODE和SQLSTATE。

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变量的值就可以在开始执行处理程序时获得。