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, once a column is referenced by a column function, the data 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_name)
Example
This example shows how the binary data in the source column ACCT_CREATE_DATE
will be copied to the target column ACCT_CHIEF_COMPLAINT
.
MAP \PROD.$DATA1.FINANCE.ACCTOLD, TARGET $DATA01.REPT.ACCT, COLMAP (USEDEFAULTS, ACCT-CHIEF-COMPLAINT = @IF (@NUMBIN (ACCT-CREATE-DATE) < 12345, "xxxxxx", @BINARY(ACCT-CHIEF-COMPLAINT) );