Navigator User Guide

10.5.6
- 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
- 10.4.0

Back Next

Step 1. Add a Data Map

In this step, you add a data map for a sequential flat file and import a COBOL copybook.

To add the data map, use data set members that ship with PowerExchange on the z/OS system.

The following table describes the data set members:

Data Set Member	Description
KSDSDAT	Data file that contains source data.
KSDSCOB	COBOL copybook that you import to define the layout of the data.

On the

Resources

tab in the

Resource Explorer

, click

Add

Data Map

In the

Name

dialog box, define properties for the data map.

The following table describes the properties:

Property	Value
Schema Name	demo
Data Map Name	userexit
Access Method	SEQ

Also, select the

Import Record Definitions

option.

Click

In the

SEQ Access Method

dialog box, enter information about the data file.

The following table describes the information to enter:

Property	Value	Notes
File Name	`PWX_installation_dataset`.DTLDEMO(KSDSDAT)	Where `PWX_installation_dataset` is the PowerExchange installation data set. For example, you might enter the following value for the file name: PWX.V901.DTLDEMO(KSDSDAT)
Record Format	Default	-
Skip First	0	-

Also, verify that the

File List Processing

option is disabled. By default, this option is disabled.

Click

Finish

In the

Import Copybook - Source Details

dialog box, define properties for the copybook.

The following table lists the values to enter:

Property	Value
Source	Remote
Type	COBOL
Column Range Start	7
Column Range End	72

Click

In the

Import Copybook - Remote Cobol Details

dialog box, define properties for the copybook on the remote system.

The following table describes the information to enter:

Property	Value	Notes
File Name	`PWX_installation_dataset`.DTLDEMO(KSDSCOB)	Where `PWX_installation_dataset` is the PowerExchange installation data set. For example, you might enter the following value for the file name: PWX.V901.DTLDEMO(KSDSCOB)
Location	Node for the z/OS system	-
UserID	The user ID for the z/OS system	-
Password	The password or valid PowerExchange passphrase for the user ID on the z/OS system. A passphrase for z/OS access 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. On z/OS, 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.	-
Save File Locally As	A name for the copybook file on the local Windows system	-

If you want to preview the copybook, click

Preview

. After you preview the copybook, close the preview window.

Click

In the

Import Copybook - Configuration Details

dialog box, review the selected actions for imported records, fields, and tables, and click

Finish

In the

Import Copybook Information

window, review the information for the import and click

In the

Record Definition

dialog box for the MASTER_REC record, click

The

Copybook Redefines

message box appears indicating that two definitions for the BIN_NO field exist in the copybook. For this example, the first definition is the correct one.

To accept the first definition for the BIN_NO field, click

Import

Goto Current Line

. Then, click

Import

Resume

to resume the import.

The

Cobol Import

window displays the imported copybook and the

Copybook Message Log

window displays the results of the import operation.

Close the

Cobol Import

window.

To verify that the data map was added correctly, on the

Resources

tab in the

Resource Explorer

, select the MASTER_REC table and click

File

Database Row Test

When you are prompted to send the data map to a remote location, click

Yes

The

Data Map Remote Node

dialog box appears.

In the

Data Map Remote Node

dialog box, enter the user ID, password, and the node for the

z/OS

system.

The

Database Row Test

dialog box appears.

In the

Database Row Test

dialog box, accept the default values and click

The

Database Row Test Output

window displays the results of the database row test.

The following image displays the

Database Row Test Output

window:

Calling a User Exit Program by Using the PowerExchange CallProg Function - Example

Rename Saved Search

Table of Contents

Navigator User Guide

Navigator User Guide

Step 1. Add a Data Map

Step 1. Add a Data Map