SAP ABAP Data Element DB2NROWSD (Number of records in a table)
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 | DB2NROWSD |
| Short Description | Number of records in a table |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | DEC15 | |
| Data Type | DEC | Counter or amount field with comma and sign |
| Length | 15 | |
| Decimal Places | 0 | |
| Output Length | 19 | |
| 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 | Records |
| Medium | 15 | Table records |
| Long | 24 | Number of table records |
| Heading | 0 |
Documentation
Definition
Number of records in a table.
This value corresponds to field CARDF in the DB2 directory table SYSIBM.SYSTABLES. This field can only be maintained by DB2 with the utility RUNSTATS, which has to be triggered externally. The given value could therefore be obsolete. The field STATSTIME in table SYSIBM.SYSTABLES shows when the field was last updated.
If there are no statistics available, the value 0 is displayed.
History
| Last changed by/on | SAP | 20070813 |
| SAP Release Created in |
