VARGRAPHIC (length)

This keyword defines a variable-length graphic string field.

A 2-byte length field that contains the length of the graphic string in double-byte characters precedes the string. The length does not include the two length bytes.

The format of the field overrides FIXEDVARCHAR YES.

For conversions from a CHARACTER or VARCHAR keyword column, the following guidelines apply:

  • If the column length is greater than two times the specified field length, either the source values must contain DBCS blanks for the difference, or you must specify VARGRAPHIC (length).

  • The conversion uses the encoding scheme of the column.

For conversions from a GRAPHIC or VARGRAPHIC column, the following guidelines apply:

  • If the column length is greater than the specified field length, either the source values must contain DBCS blanks for the difference, or you must specify VARGRAPHIC (length).

  • If the column length is less than the specified field length,  BMC AMI Unload sets the length of the field to the length of the column.

TRUNCATE

TRUNCATE tells BMC AMI Unload  to truncate a string if it is longer than the field.

Was this page helpful? Yes No Submitting... Thank you

Comments