PowerExchange for CDC and Mainframe
- PowerExchange for CDC and Mainframe 10.4.1
- All Products
Column Name
| Description
| Extended information
|
---|---|---|
qualifier_1
| Creator/Schema name.
| No
|
qualifier_2
| PowerExchange Data Map name will be returned, or null for NRDB2.
| No
|
tablename
| Return table name.
| No
|
comments
| Comments column always present. Comment information is included only if requested by specifying the comments indicator in the describe.
| No
|
type
| Type of object for which metadata was returned, such as TABLE or MATERIALIZED VIEW.
| No
|
Acc_mth
| The access method (from data map)
| Yes
|
Acc_mths01
| Adabas
| Database ID
|
Acc_mths01
| SEQ, KSDS, ESDS
| MapFileName
|
Acc_mths01
| IDMS
| MapSubSchemaName
|
Acc_mths01
| ODBA or DL/I
| DBDName
|
Acc_mths01
| Datacom
| Database ID
|
Acc_mths01
| CAPX or CAPXRT
| The access method of the original data map
|
Acc_mths01
| Other access methods
| NULL
|
Acc_mths02
| Adabas
| File Number
|
Acc_mths02
| ODBA or DL/I
| DBDType
|
Acc_mths02
| Datacom
| Table record length
|
Acc_mths02
| IDMS or VSAM
| C (if table is valid for data capture) or NULL
|
Acc_mths02
| CAPX
| Condense option (Full, Part or None)
|
Acc_mths02
| DB2UNLD
| Null indicator value
|
Acc_mths02
| Other access methods
| NULL
|
Acc_mths03
| Datacom
| Table ID
|
Acc_mths03
| IDMS or VSAM
| Database name
|
Acc_mths03
| CAPX or CAPXRT
| Creator of the capture registration
|
Acc_mths03
| DB2
| DB2 Sub system ID
|
Acc_mths03
| DB2UNLD
| Unload type
|
Acc_mths03
| Other access methods
| Not Used. (comma needed to maintain position of later fields)
|
Acc_mths04
| Datacom
| Version
|
Acc_mths04
| CAPX or CAPXRT
| Name of the registration's source table
|
Acc_mths04
| DB2 or DB2UNLD
| DB2 table name
|
Acc_mths04
| Other access methods
| Not Used. (comma needed to maintain position of later fields)
|
Acc_mths05
| Datacom
| Recovery (Y/N)
|
Acc_mths05
| DB2UNLD
| Unload file name
|
Acc_mths05
| Other access methods
| Not Used. (comma needed to maintain position of later fields)
|
Acc_mths05
| Base Record
| Describes the dependencies for a table. For example,
For Datacom, Base Record returns the short table name.
|