SQL error code

Error codes are allocated for your DataBlade® module by the HCL Informix® DataBlade Developer's Program registry, ensuring that your error codes do not conflict with built-in error codes or with those error codes 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 alphabetic 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 - 9 and the letters A through Z in the fifth position.

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