View or edit properties for an DB2 unload file data map.
File Name
Required. The DB2 unload file name. Valid characters are ASCII characters and the pound and yen signs.
DB Instance
The DB2 database instance name. Valid characters are ASCII characters and the pound and yen signs.
Table Name
Required. The DB2 table name. Enter the table name or click the Browse button to enter filter criteria for the table.
Unload Type
The unload type. For bulk access to unload files, the following IBM and BMC formats are supported:
REORG UNLOAD
DSNTIAUL/BMC UNLOAD+
DSNUTILB UNLOAD
UNDEFINED. By default, this type is generated with null indicators, and count fields in the same position as in the REORG UNLOAD EXTERNAL type.
Instead of using these unload types, you can modify these statements to meet specific requirements. You can move or delete these statements to correspond to user-defined unload formats, but PowerExchange interprets them if they precede the data field to which they apply.
Encoding
The encoding scheme. The options are:
Default
. PowerExchange uses the default encoding scheme for the operating system.
EBCDIC
. EBCDIC.
ASCII HIEND
. ASCII high endian.
ASCII LOEND
. ASCII little endian.
Default is
Default
.
Codepage
The code page that describes the character set for the character data in the database. For the
Default
encoding, you cannot select a code page. PowerExchange uses the default code page for the operating system.