Table of Contents

Search

  1. Preface
  2. PowerExchange Navigator Introduction
  3. Data Maps
  4. Data Maps for Specific Data Sources
  5. Copybooks
  6. Registration Groups and Capture Registrations
  7. Extraction Groups and Extraction Maps
  8. Personal Metadata
  9. Database Row Test
  10. PowerExchange Navigator Examples
  11. Appendix A: PowerExchange Functions for User-Defined Fields
  12. Appendix B: User Access Method Programs
  13. Appendix C: Application Groups and Applications
  14. Appendix D: Data Map Properties
  15. Appendix E: Record, Field, and Table Properties
  16. Appendix F: DTL__CAPXTIMESTAMP Time Stamps
  17. Appendix G: Trace for Creating a Memory Map When Importing a COBOL Copybook

Navigator User Guide

Navigator User Guide

Import Copybook - Remote DB2 Catalog Details Dialog Box

Import Copybook - Remote DB2 Catalog Details Dialog Box

Enter information for the remote DB2 copybook.
DB Instance
Enter the name of the DB2 database instance.
Location
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.

0 COMMENTS

We’d like to hear from you!