VARBINARY
This keyword defines a binary string field that varies in length.
You can also specify this field type as BINARY VARYING. For more information, see Additional-variable-field-considerations.
(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.
TRIM | TRIM tells UNLOAD PLUS 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. UNLOAD PLUS applies TRIM before TRUNCATE. UNLOAD PLUS ignores the TRIM option if you specify FORMAT DSNTIAUL. |
|---|
TRUNCATE
TRUNCATE tells UNLOAD PLUS to truncate a string if it is longer than the field (even after the TRIM option has truncated trailing hexadecimal zeros). UNLOAD PLUS performs TRUNCATE after TRIM.
Related topic