Skip to Content
Information

This site will undergo a brief period of maintenance on Friday, 18 December at 12:30 AM Central/12:00 PM IST. During a 30 minute window, site availability may be intermittent.

VARBINARY

This keyword defines a binary string field that varies in length. 

You can also specify this field type as BINARY VARYING.

(length)

The length indicates the number of single-byte characters. A 2-byte length field that contains the length of the character string in bytes precedes the VARBINARY string. This length does not include the two length bytes.


Related topics

BMC-AMI-Unload-field-specification
BMC-AMI-Unload-field-specification

SELECT statement options (UNLOAD syntax)

BMC AMI Unload option descriptions
BMC-AMI-Unload-Option-descriptions

UNLOAD-syntax-diagrams


TRIM

TRIM tells BMC AMI Unload to remove as many trailing hexadecimal zeros from the string as needed to make the string length match the length you specify. If the string is still too long, a conversion error occurs. BMC AMI Unload applies TRIM before TRUNCATE. BMC AMI Unload applies TRIM before TRUNCATE.

TRUNCATE

TRUNCATE tells BMC AMI Unload to truncate a string if it is longer than the field (even after the TRIM option has truncated trailing hexadecimal zeros). BMC AMI Unloadperforms TRUNCATE after TRIM.



 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Unload for Db2 13.1