PowerExchange for CDC and Mainframe
- PowerExchange for CDC and Mainframe 10.5
- All Products
Option
| Description
|
---|---|
Local
| The copybook is located on the PowerExchange Navigator system.
|
Remote
| The copybook is located on a remote system.
|
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
|
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.
|
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.
|
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.
|