SQL Error Code

Error codes are allocated for your DataBlade module by the Informix DataBlade Developers Program registry, ensuring that your error codes do not conflict with built-in error codes and those of other DataBlade modules.

Error message codes, which must conform to the SQL standard for SQLSTATE, have the following format:

• The first character is the letter U.
• The second and third characters are unique alphabetical characters assigned to the DataBlade module.
• The fourth and fifth characters are alphanumeric. Using this format, a DataBlade module can have up to 1,296 error codes. If you anticipate no more than 36 error codes, you can use the three-character object name prefix in the second, third, and fourth positions, and the digits 0 through 9 and the letters A through Z in the fifth position.

See the DataBlade Developers Kit User's Guide for information on how to obtain your error codes.