SAP ABAP Table DB2_COLUMN_DESCRIPTION (DB2 z/Os: Column description of a DB 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

Basic Data

Table Category	INTTAB	Structure
Structure	DB2_COLUMN_DESCRIPTION	Table Relationship Diagram
Short Description	DB2 z/Os: Column description of a DB Table

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	NAME	☐	DB2COLNAML		CHAR	128	0	DB2 column name
2	COLNO	☐	DB2COLNO	DB2SINT	INT2	5	0	Numeric position of the column in the table or view
3	COLTYPE	☐	DB2COLTYPE	DB2COLTYPE	CHAR	8	0	Column type specified in the column definition
4	LENGTH	☐	DB2COLLEN	DB2SINT	INT2	5	0	Length attribute of the column
5	SCALE	☐	DB2SCALE	DB2SINT	INT2	5	0	Scale of decimal data
6	NULLS	☐	DB2BOOLEAN		CHAR	1	0	bool type
7	DEFAULT	☐	DB2FLAG		CHAR	1	0	c1 flag
8	DFTVALUE	☐	DEFAULT_VA	DEFAULT_VA	CHAR	75	0	Default value for a DB column
9	BITDATA	☐	DB2BOOLEAN		CHAR	1	0	bool type
10	LENGTH2	☐	DB2COLLEN2		INT4	10	0	column length

History

Last changed by/on	SAP	20130604
SAP Release Created in	731