Previous Topic Next topic Print topic


EBCDIC_TO_ASCII

Restriction: This topic applies to Windows environments only.

Specifies whether EBCDIC data should be converted to ASCII during DSNTIAUL imports. The syntax is:

EBCDIC_TO_ASCII = {Y | N | NA} [,{Y | N | NA}]...;

where the number of Ys, Ns and NAs is equal to the number of fields in the table. If EBCDIC_TO_ASCII is set to N, data are not converted to ASCII. If EBCDIC_TO_ASCII is set to Y (default), the data are assumed to be EBCDIC and are converted to the ASCII equivalent. If EBCDIC_TO_ASCII is set to NA, conversion is not applicable for the field type.

EBCDIC_TO_ASCII is an optional Batch Import command.

Note: When saving specifications for DB2 DSNTIAUL format, an EBCDIC_TO_ASCII statement is included with all fields set to Y (yes).

For example:

EBCDIC_TO_ASCII = n,n,n,n;

defines this import command so that none of the fields of a four-column table are converted to ASCII in this transaction.

Previous Topic Next topic Print topic