2.6 @BINARY

Use the @BINARY function when a source column referenced by a column-conversion function is defined as a character column but contains binary data that must remain binary on the target. By default, binary data in a character column is converted (if necessary) to ASCII and assumed to be a null-terminated string. The @BINARY function copies arbitrary binary data to the target column.

Syntax

@BINARY (column)

column

The name of the target column to which the data will be copied.

Example

The following shows how @BINARY can be used to copy the data from the source column ACCT_CREATE_DATE to the target column ACCT_COMPLAINT.

ACCT_COMPLAINT =
@IF ( @NUMBIN (ACCT_CREATE_DATE ) < 48633, 'xxxxxx',
@BINARY (ACCT_COMPLAINT))