HEX and binary literals usage

An application developer can use standard SQL to specify HEX and binary literal values in SQL statements for SELECT, INSERT, UPDATE and DELETE queries.

Examples of valid IMS Universal JDBC driver HEX and binary literal usage

Supporting HEX and binary literals in SQL

The IMS Universal JDBC driver supports the usage of HEX and binary literals in the SQL syntax. The following examples show the SQL syntax for representing HEX and binary literals:


HEX
0xF1F1F1
x'F1F1F1'
X'F1F1F1'
Binary 
0b00000100
b'00000100'
B'00000100'
SQL with HEX and binary literals examples

SELECT    
SELECT * FROM TABLE WHERE HEX_VALUE = 0xF1F2 and HEX_VALUE3 = x'F1F1' and HEX_VALUE4 = X'F2F1'
SELECT * FROM TABLE WHERE BIN_VALUE = 0b00000100 and BIN_VALUE3 = b'00000100' and BIN_VALUE4 = B'00000100'

INSERT
INSERT INTO HOSPITAL (HOSPCODE, HOSPNAME) VALUES ('R1210010000A', x'F1F2F3C4')