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
Basic Data
| Data Element | DB2BASECOLNAME |
| Short Description | Name of the LOB column in the base table causing the LOB TS |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | DB2COLNAME | |
| Data Type | CHAR | Character String |
| Length | 18 | |
| Decimal Places | 0 | |
| Output Length | 18 | |
| 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 | Base Col. |
| Medium | 15 | Base column |
| Long | 40 | Name of the LOB column in the base table |
| Heading | 40 | Name of the LOB column in the base table |
Documentation
Definition
LOB table spaces hold large object data such as graphics, video, or very large text strings. A LOB table space is always associated with the table space that contains the logical LOB column values. The table space that contains the table with the LOB columns is called the base table space.
This relationship is organized in such a way, that each column containing a LOB value needs an auxiliary table (and corresponding auxiliary LOB table space) created for the LOB column. A base table space that is partitioned must have one auxiliary table for each partition of each LOB column.
The actual LOB data is stored in these auxiliary tables. The base table only contains a row identifier for each row and an indicator column for each of its LOB columns.
This column contains the name of the column in the base table, that caused the generation of the LOB TS.
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in | 700 |
