PowerExchange for CDC and Mainframe
- PowerExchange for CDC and Mainframe 10.4.1
- All Products
Column Name | Description | Extended Information |
---|---|---|
Qualifier1 | Creator/Schema name. | No |
Qualifier2 | PowerExchange data map name will be returned, or null for NRDB2. | No |
Tablename | Return table name. | No |
Column_name | Column name. | No |
Type | Field format. | No |
Precision | Field length. | No |
Scale | Decimal places. | No |
Nullable | Nullable. | No |
Detail_type | Internal column type representation. | No |
Comments | Comments column always present. Comment information is included only if requested by specifying the comments indicator in the describe. | No |
Key_type | Reserved for future use. | No |
Ref_qualifier_1 | Reserved for future use. | No |
Ref_qualifier_2 | Reserved for future use | No |
Ref_table_name | Reserved for future use | No |
Ref_column_name | Reserved for future use | No |
Base Record | Describes the dependencies for a table. For example, ROOT(SEG2(SEG3,SEG4),SEG5). | NRDB |
Base Field | Column base field, such as ROOT:ROOTKEY . | NRDB |
Base Field Type | Field type of the column's base field (CHAR, VARCHAR etc.). | NRDB |
Base Field Offset | Returns the offsets of the field within the record. There is a case when no offset is returned. If you have an array of fields and you collapse the array when you generate the table the offset of those fields will be 0. | NRDB |
Field Usage | Usage of field. For example, COMP or DISPLAY for Cobol. | NRDB |
Field Level | Indent level of the field in the Cobol copybook. | NRDB |
Original Field Name | Original name of the field as given in the Cobol copybook. | NRDB |
Field Picture | Cobol picture format of the field. | NRDB |
CCSID | CCSID. | DB2 |
Internal_cp | Internal code page. | DB2, NRDB, NRDB2, CAPX, and CAPXRT |
Codepage_name | Code page name. | DB2, NRDB, NRDB2, CAPX, and CAPXRT |
Powercenter_name | PowerCenter name of the code page. | NRDB, NRDB2, CAPX, and CAPXRT |