Binary-string constants
A binary-string constant specifies a varying-length
binary string. The form of a binary-string constant follows:
- An X followed by a sequence of characters that starts and ends
with a string delimiter. The characters between the string delimiters must
be an even number of hexadecimal digits. Blanks between the string delimiters
are ignored. The number of hexadecimal digits must not exceed 32740. A hexadecimal
digit is a digit or any of the letters A through F (uppercase or lowercase).
The CCSID assigned to the constant is 65535.
Note that the syntax of a binary string constant is identical to the second
form of a character constant. A constant of this form is only treated as a
binary string constant if:
- The SET OPTION statement was specified with the binary string option (SQLCURRULE = *STD),
- the SQLCURRULE(*STD) parameter was specified on the CRTSQLxxx
or RUNSQLSTM command, or
- the SQL rules option was specified on the Change Session Attributes
panel of Interactive SQL.
Example
X'FFFF'
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.