Location from which to import the DB2 catalog. Options are:
Local
. The catalog is located on the PowerExchange Navigator system.
Remote
. The catalog is located on a remote system.
If you select
Remote
, the
Location
list includes the locations that are defined by NODE statements in the dbmover.cfg configuration file on the PowerExchange Navigator system. Select
local
in the list if the copybook is located on the PowerExchange Navigator system
Table Name
Enter the table name, or click the Browse button to browse to enter filter criteria for a table.
UserID
Enter a user ID that has the authority to access the database.
For databases on supported Linux, UNIX, or Windows systems, if you have enabled PowerExchange LDAP user authentication and disabled relational pass-through authentication, the user ID is the enterprise user name. For more information, see the
PowerExchange Reference Manual
.
Password
Enter a password for the specified user ID.
To access to a DB2 catalog on z/OS, you can enter a valid PowerExchange passphrase instead of a password. A PowerExchange passphrase can be from 9 to 128 characters in length and can contain the following characters:
Uppercase and lowercase letters
The numbers 0 to 9
Spaces
The following special characters:
’ - ; # \ , . / ! % & * ( ) _ + { } : @ | < > ?
The first character is an apostrophe.
Passphrases cannot include single quotation marks (‘), double quotation marks (“), or currency symbols.
The allowable characters in the IBM IRRPHREX exit do not affect the allowable characters in PowerExchange passphrases.
A valid RACF passphrase can be up to 100 characters in length. PowerExchange truncates passphrases longer than 100 characters when passing them to RACF for validation.
To use passphrases, ensure that the PowerExchange Listener runs with a security setting of SECURITY=(1,N) or higher in the DBMOVER member. For more information, see "SECURITY Statement" in the
PowerExchange Reference Manual
.
Save File Locally As
Enter the path and file name on the local system where a copy of the copybook 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 are padded in the unload file.
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 to be accessed.