Navigator User Guide

10.4.0
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0 HotFix 1

Back Next

Adding a Data Map

When you add a data map, specify a schema name, a data map name, and an access method.

If the data map is for a flat file or sequential data set, associate it with a data file.

Optionally, import a copybook to define the layout of the data in a data source. For Adabas data maps, you can import an Adabas field definition table (FDT) and Adabas keys.

On the

Resources

tab in the

Resource Explorer

, click

Add

Data Map

The

Name

dialog box appears.

Enter information about the data map.

The following table describes the information to enter:

Option	Description
Schema Name	Enter a user-defined schema name. PowerExchange uses this name as the first part of the data map name, as follows: `schema_name`.`data_map_name` Valid values are alphanumeric characters. Must begin with an alphabetic character. Maximum length is 10 characters.
Data Map Name	Enter a user-defined map name. PowerExchange uses this name as the second part of the data map name, as follows: `schema_name`.`data_map_name` Valid values contain only alphanumeric characters and begin with a letter. Maximum length is 10 characters.
Access Method	Select one of the following access methods: ADABAS . Adabas file. DATACOM . CA Datacom/DB file. DB2 . DB2 for i5/OS, DB2 for Linux, UNIX, and Windows, or DB2 for z/OS database. DB2UNLD . DB2 unload file. DL/1 BATCH . DL/I batch or BMP access to an IMS database on z/OS. ESDS . VSAM Entry Sequenced Data Set (ESDS) on z/OS. IDMS . CA IDMS/DB database on z/OS. IMS ODBA . IMS ODBA access to an IMS database on z/OS. The ODBA queries run as subtasks of the PowerExchange Listener on z/OS. KSDS . VSAM Key Sequenced Data Set (KSDS) on z/OS. MQSERIES . IBM MQSeries message queue. RRDS . VSAM Relative Record Data Set (RRDS) on z/OS. SEQ . Flat file. TAPE . Data set on tape. USER . User-defined user access method program. You can override the DL/1 BATCH or IMS ODBA access method with the other available method for a PowerCenter session or database row test.
Import Record Definitions	Select this option to import a copybook into the data map. Clear this option to add only the data map. Default is selected.
Import Key Fields/FDT	Adabas. Select this option to import an Adabas FDT and Adabas keys into the data map. Clear this option to add only the data map. Default is selected.

Enter information in the dialog box for the access method that you choose.

The following table lists the dialog box that appears for each access method:

Access Method	Dialog Box	Reference
ADABAS	ADABAS Access Method	Data Map Properties - ADABAS Access Method
DATACOM	DATACOM Access Method	Data Map Properties - DATACOM Access Method
DB2	DB2 Access Method	Data Map Properties - DB2 Access Method
DB2UNLD	DB2UNLD Access Method	Data Map Properties - DB2UNLD Access Method
DL/1 BATCH	DL/1 Batch Access Method	Data Map Properties - DL/I Batch or IMS ODBA Access Method
ESDS	ESDS Access Method	Data Map Properties - ESDS Access Method
IDMS	IDMS Access Method	Data Map Properties - IDMS Access Method
IMS ODBA	IMS ODBA Access Method	Data Map Properties - DL/I Batch or IMS ODBA Access Method
KSDS	KSDS Access Method	Data Map Properties - KSDS Access Method
MQSERIES	MQSeries Access Method	Data Map Properties - MQSeries Access Method
RRDS	RRDS Access Method	Data Map Properties - RRDS Access Method
SEQ	SEQ Access Method	Data Map Properties - SEQ Access Method
TAPE	TAPE Access Method	Data Map Properties - TAPE Access Method
USER	USER Access Method	Data Map Properties - USER Access Method

For an Adabas data map, if you selected the

Import Key Fields/FDT

option, click

. Then, enter information in the

Adabas FDT Import

dialog box.

The following table describes the information to enter:

Option	Description
UserID	Enter an Adabas user ID that has the authority to access the location.
Password	Enter a password for the specified user ID. If you specify a user ID and omit the password, the PowerExchange Navigator prompts you to enter the password in the Missing Password dialog box.
Location	Select the location of the FDT. Options are: Local . The FDT is located on the PowerExchange Navigator system. Remote . The FDT is located on a remote system. The locations displayed in the Location list are defined by NODE statements in the dbmover.cfg configuration file on the PowerExchange Navigator system. Default is Local .
File Password	If the FDT file is password-protected, enter the password to access the file.
Save User ID and Password(s) for session	Select this option to save the user ID and password, and the file password if specified, for the remainder of the session. Default is selected.