Códigos De Error Db2 - Sql
Páginas: 30 (7328 palabras)
Publicado: 26 de febrero de 2013
Listing of SQLSTATE values
The tables in this topic provide descriptions of SQLSTATE codes that can be returned to applications by DB2® UDB for iSeries™. The tables include SQLSTATE values, their meanings, and their corresponding SQLCODE values.
|Table 1. Class code 00: Unqualified Successful Completion |
|SQLSTATE Value|Meaning |SQLCODE Values |
|00000 |Completion of the operation was successful and did not result in any type of warning |+000 |
| |or exception condition. | |
|Table 2. Class code 01:Warning |
|SQLSTATE Value |Meaning |SQLCODE Values |
|01002 |A DISCONNECT error occurred. |+596 |
|01003 |Null values wereeliminated from the argument of a column function. |+000 |
|01004 |The value of a string was truncated when assigned to another string data type with a |+000, +445, +802, |
| |shorter length. |+20141 |
|01005 |Insufficient number ofentries in an SQLDA. |+239 |
|01006 |A privilege was not revoked. |+569 |
|01007 |A privilege was not granted. |+570 |
|01009 |The search condition is too long forthe information schema. |+177 |
|0100A |The query expression of the view is too long for the information schema. |+178 |
|0100C |One or more ad hoc result sets were returned from the procedure. |+466 |
|0100D |The cursor that was closed has been reopened onthe next result set within the chain. |+467 |
|0100E |The procedure returned too many result sets. |+464, +20206 |
|01503 |The number of result columns is larger than the number of host variables provided. |+000, +030 |
|01504 |The UPDATE or DELETE statement does not include a WHEREclause. |+000, +088 |
|01505 |The statement was not executed because it is unacceptable in this environment. |+084 |
|01506 |An adjustment was made to a DATE or TIMESTAMP value to correct an invalid date |+000 |
| |resulting from an arithmetic operation.| |
|01515 |The null value has been assigned to a host variable, because the non-null value of the|+304 |
| |column is not within the range of the host variable. | |
|01517 |A character that cannot be converted was replaced with a substitute character.|+335 |
|01519 |The null value has been assigned to a host variable, because a numeric value is out of|+802 |
| |range. | |
|01520 |The null value has been assigned to a host variable, because the characters cannot be...
The tables in this topic provide descriptions of SQLSTATE codes that can be returned to applications by DB2® UDB for iSeries™. The tables include SQLSTATE values, their meanings, and their corresponding SQLCODE values.
|Table 1. Class code 00: Unqualified Successful Completion |
|SQLSTATE Value|Meaning |SQLCODE Values |
|00000 |Completion of the operation was successful and did not result in any type of warning |+000 |
| |or exception condition. | |
|Table 2. Class code 01:Warning |
|SQLSTATE Value |Meaning |SQLCODE Values |
|01002 |A DISCONNECT error occurred. |+596 |
|01003 |Null values wereeliminated from the argument of a column function. |+000 |
|01004 |The value of a string was truncated when assigned to another string data type with a |+000, +445, +802, |
| |shorter length. |+20141 |
|01005 |Insufficient number ofentries in an SQLDA. |+239 |
|01006 |A privilege was not revoked. |+569 |
|01007 |A privilege was not granted. |+570 |
|01009 |The search condition is too long forthe information schema. |+177 |
|0100A |The query expression of the view is too long for the information schema. |+178 |
|0100C |One or more ad hoc result sets were returned from the procedure. |+466 |
|0100D |The cursor that was closed has been reopened onthe next result set within the chain. |+467 |
|0100E |The procedure returned too many result sets. |+464, +20206 |
|01503 |The number of result columns is larger than the number of host variables provided. |+000, +030 |
|01504 |The UPDATE or DELETE statement does not include a WHEREclause. |+000, +088 |
|01505 |The statement was not executed because it is unacceptable in this environment. |+084 |
|01506 |An adjustment was made to a DATE or TIMESTAMP value to correct an invalid date |+000 |
| |resulting from an arithmetic operation.| |
|01515 |The null value has been assigned to a host variable, because the non-null value of the|+304 |
| |column is not within the range of the host variable. | |
|01517 |A character that cannot be converted was replaced with a substitute character.|+335 |
|01519 |The null value has been assigned to a host variable, because a numeric value is out of|+802 |
| |range. | |
|01520 |The null value has been assigned to a host variable, because the characters cannot be...
Leer documento completo
Regístrate para leer el documento completo.