-20163   HEXADECIMAL CONSTANT GX IS NOT ALLOWED

Explanation

A hexadecimal graphic string constant, GX, was used in a statement when one of the following two conditions was true:
  • The MIXED DATA installation option is set to NO.
  • The application encoding scheme is UNICODE.
  • The GX constant was specified as a column default value in a WITH DEFAULT clause.
  • The GX constant was specified as a limit key value in an ENDING AT clause.

System action

The statement cannot be processed.

Programmer response

If your data is not graphic, use an X hexadecimal constant instead of a GX constant. If your MIXED DATA installation option is set to NO, contact your system administrator to set up the installation options properly for use with the GX constant. If your application encoding scheme is UNICODE, use a UX hexadecimal constant instead of GX.

SQLSTATE

560B9