DB2CONVTOOL - DB2 z/OS: Recommendations for data conversions
DB2 z/OS: Recommendations for data conversions information is stored in SAP table DB2CONVTOOL.
It is part of development package STU2 in software component BC-DB-DB2. This development package consists of objects that can be grouped under "CCMS for DB2 for OS/390".
It is part of development package STU2 in software component BC-DB-DB2. This development package consists of objects that can be grouped under "CCMS for DB2 for OS/390".
Fields for table DB2CONVTOOL
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| QUALIFIER | Schema name to qualify tables (statistics, catalog, created) | X | DB2CCSCHEM | CHAR | 128 | |
| OBJECTNAME | Object name (table, index, column) | X | DB2OBJECTNAME | CHAR | 128 | |
| OBJECTTYPE | Type of object e.g. TS, IS, TB, IX | X | DB2OBJECTTYPE | CHAR | 2 | |
| CONVERTTYPE | DB2 Type of Conversion | X | DB2CONVERTTYPE | CHAR | 10 | |
| ELEMENT | DB2 z/OS: element of an object | X | DB2ELEMENT | CHAR | 16 | |
| SUBKEY | DB2 z/OS: subkey of an object | X | DB2SUBKEY | CHAR | 16 | |
| VALUE | DB2 z/OS: Value of a certain key in random format | DB2VALUE128 | CHAR | 128 |