sqlstate

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

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

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

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

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

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

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

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

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

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

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

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

SQLSTATE = 57019 when backing up the database .

SQLSTATE=57019（在备份数据库时）。

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

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

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

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

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

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

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变量都已被声明，那么它们将为语句包含相应的值，并且可以检查这些值。

You can obtain the SQLSTATE , diagnostic messages , and native error codes information by calling the SQLGetDiagRec () function , the SQLGetDiagField () function , or both .

可以通过调用SQLGetDiagRec（）函数、SQLGetDiagField（）函数或者同时调用这两个函数来获得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变量的值就可以在开始执行处理程序时获得。

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。