Navigator User Guide

Back Next

Import Copybook - Local DB2 Catalog Details Dialog Box

Enter information for the local DB2 catalog.

DB Instance: Enter the instance name of the DB2 database.
Location: Select
Local
for the location of the DB2 catalog. The catalog is on the system where the PowerExchange Navigator runs.
Table Name: Enter the table name for which you are importing a DB2 catalog, or click the Browse button to enter filter criteria for a table.
UserID: Enter a user ID that has authority to access the database.
Password: Enter a password for the specified user ID.
Save File Locally As: Enter the path and file name on the local system where a copy of the DB2 catalog is saved, or click the
Browse
button to browse to a file.
Null Indicator: For a DB2 unload file data map, enter the hexadecimal value of the null indicator that is used in the unload file.
Pad Variable: For a DB2 unload file data map, select this option if variables in the unload file are padded.

This option corresponds to the BMC UNLOAD PLUS FIXEDVARCHAR.
Preview/Amend Columns: Displays the
DB2 Column Selection
dialog box, which enables you to view or select the columns in the table that will be accessed.