SAP ABAP Data Element DB2TABCAT (DB2 for OS/390: Table category)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-DB2 (Application Component) DB2 for z/OS
⤷
STU2 (Package) CCMS for DB2 for OS/390
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DB-DB2 (Application Component) DB2 for z/OS⤷
STU2 (Package) CCMS for DB2 for OS/390
Basic Data
| Data Element | DB2TABCAT |
| Short Description | DB2 for OS/390: Table category |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | DB2TABCAT | |
| Data Type | CHAR | Character String |
| Length | 2 | |
| Decimal Places | 0 | |
| Output Length | 2 | |
| Value Table |
Further Characteristics
| Search Help: Name | ||
| Search Help: Parameters | ||
| Parameter ID | ||
| Default Component name | ||
| Change document | ||
| No Input History | ||
| Basic direction is set to LTR | ||
| No BIDI Filtering |
Field Label
| Length | Field Label | |
| Short | 10 | Table Cat. |
| Medium | 15 | Table category |
| Long | 20 | Table categorisation |
| Heading | 0 |
Documentation
Definition
The table category or access category is an attribute of the table which describes what kind of access is typically done for the table. It also takes into account the table size. Possible values are:
- C1 Access type = sequential, changes < 10%
- C2 Access type = sequential, changes > 10%
- C3 Access type = random, changes < 10%, size = small
- C4 Access type = random, changes < 10%, size = large
- C5 Access type = random, changes > 10%, size = small
- C6 Access type = random, changes > 10%, size = large
- C7 Insert and/or delete only
- C8 Reserved for tables VBLOG, VBDATA, VBHDR, VBMOD
History
| Last changed by/on | SAP | 20070813 |
| SAP Release Created in | 700 |
