Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • PowerExchange for CDC and Mainframe 10.5.5
  • All Products

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

Back Next

Import Copybook - Source Details Dialog Box

Import Copybook - Source Details Dialog Box

Enter information about the copybook that you are importing into a data map or a record.
Source
Select the location of the copybook.
The following table describes the options:
Option
Description
Local
The copybook is located on the PowerExchange Navigator system.
Remote
The copybook is located on a remote system.
Type
Select the type of copybook. The type of copybook that you can import depends on the access method of the data map into which you are importing the copybook. For example, you can import a copybook type of ADACMP into a data map defined with the ADABAS access method only.
To import a COBOL or PL/1 copybook, select
COBOL
 or
PL/1
, respectively.
The following table lists the types of data maps, by access method and corresponding data source, into which you can import a COBOL or PL/1 copybook:
Import into Data Maps Defined with Access Methods
Corresponding Data Source
ADABAS
Adabas file
DATACOM
CA Datacom/DB file
DB2UNLD
DB2 unload file
DL/1 BATCH
IMS database
ESDS
VSAM ESDS
IDMS
CA IDMS/DB database
IMS ODBA
IMS database accessed through a PowerExchange Listener
KSDS
VSAM KSDS
MQSERIES
IBM MQSeries message queue
RRDS
VSAM RRDS
SEQ
Flat file or sequential data set
TAPE
Tape data set
USER
User access method program
The following table describes the
Type
 options and lists the types of data maps, by access method and corresponding data source, into which you can import each type of copybook other than a COBOL or PL/1 copybook:
Option
Description
Import into Data Maps Defined with Access Methods
Corresponding Data Source
ADACMP
File created by using the ADACMP utility.
ADABAS
Adabas file
DATACOM
Datacom copybook. Provides combined CA Datacom/DB schema and COBOL copybook information.
DATACOM
CA Datacom/DB file
DB2 Catalog
DB2 catalog.
DB2
DB2 for i5/OS, DB2 for Linux, UNIX, and Windows, or DB2 for z/OS database
DB2 Catalog
DB2 catalog.
DB2UNLD
DB2 unload file
DBD
Database description block (DBD). Adds segment, key field, search field, and CCK field definitions from the IMS database, and adds tables to the data map. Also defines the hierarchical sequence of segments.
1
DL/1 BATCH
IMS database
DBD
Database description block (DBD). Adds segment, key field, search field, and CCK field definitions from the IMS database, and adds tables to the data map. Also defines the hierarchical sequence of segments.
1
IMS ODBA
IMS database accessed through a PowerExchange Listener
DDM
Natural data definition module (DDM). Provides long name and scale information.
ADABAS
Adabas file on z/OS
DDS
Data description specifications (DDS). Describes data attributes in file descriptions that are external to the application program that processes the data.
SEQ
DB2 for i5/OS data that is accessed sequentially
FDT
Field definition table (FDT). Each database file has a corresponding FDT, which defines the record structure and the content of each field in the physical file. For each field in the record, the FDT defines the level, name, length, format, options, and special field and descriptor attributes. An FDT provides short names and no scale information.
ADABAS
Adabas file
IDMS
IDMS copybook. Provides combined CA IDMS/DB schema and COBOL copybook information.
IMDS
CA IDMS/DB database
PREDICT
Predict data dictionary. Provides long name and scale information.
ADABAS
Adabas file on z/OS
TEXT
Text file, which is a delimited format file that uses an Informatica internal format.
ADABAS
Adabas file
1. When you import a DBD, PowerExchange provides full support for DBD statements that preceded the introduction of the IMS catalog in IMS 12. PowerExchange ignores all DBD enhancements that are related to the IMS catalog.
Column Range
The following table describes the start and end column range for the copybook:
Option
Description
Start
The start column number.
Valid values are from 1 through 999.
For the COBOL copybook type, default is 7.
For all other copybook types, default is 1.
End
The end column number.
Valid values are from 1 through 999.
For the COBOL and PL/I copybook types, default is 72.
For all other copybook types, default is 80.
You cannot set a column range for DBDs imported into IMS DL/1 batch data maps.
FDIC File Details
The following table describes the FDIC file details for DDM or PREDICT copybook types:
Option
Description
Database ID
The FDIC database ID.
Valid values are from 1 through 99999.
File Number
The FDIC file number.
Valid values are from 1 through 9999.
Default is 1.
0 COMMENTS
We’d like to hear from you!