SQL iQuery Script Built-in Function

ToHex

Convert data to 2-hexadecimal characters using the CVTHC MI instruction.

The TOHEX() built-in function returns 2 hexadecimal characters the represent each single character of parameter 1.

Syntax

• eval &hex = tohex( <Session Variable or value > );

The ISHEX() passes the first parameter to the cvthc MI instruction. That instruction "unfolds" the characters; creating 2 hexadecimal bytes for each single byte of parameter 1. For example, the string '38' is translated to 'F3F8'.

Parameters

1. The name of an iQuery Session Variable to be converted to hexadecimal.

SELECT SUBSTR(data,21,5) INTO &AMTDUE
FROM CUSTMAST
WHERE CUSTNO = 12;

eval &CustData = toHex(&amtDue);
if (&custData = '4040404040');
  #msg This customer has a decimal data error (blanks) in the Amount Due column
else;
  // continue normally
endif;