Navigator User Guide

Back Next

Data Map Properties - DB2UNLD Access Method

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.

Default is
Default
.