SAP ABAP Table QSYSCOLUMN (iSeries: System Catalog View of Table Fields (SYSCOLUMNS))

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB4 (Application Component) DB2 for AS/400
     ⤷ STU4 (Package) CCMS / AS/400

Basic Data

Table Category	INTTAB	Structure
Structure	QSYSCOLUMN	Table Relationship Diagram
Short Description	iSeries: System Catalog View of Table Fields (SYSCOLUMNS)

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	☐	COL_NAME	FDNAME	CHAR	30	0	iSeries: SQL column name	*
2	TBNAME	☐	TBNAME	AS4TAB	CHAR	30	0	iSeries: SQL Name of Table or View	*
3	TBCREATOR	☐	TBCREATOR	QCHAR10	CHAR	10	0	iSeries: Owner of table or view
4	COLNO	☐	ORD_POS	QINT4	INT4	10	0	iSeries: Ordinal position of field in the table
5	COLTYPE	☐	COLTYPE	QCHAR8	CHAR	8	0	iSeries: Table field data type
6	LENGTH	☐	LENGTH	QINT4	INT4	10	0	iSeries: Table field length
7	SCALE	☐	NUM_SCALE	QINT4	INT4	10	0	iSeries: Table field numeric scale
8	NULLS	☐	NULLS	QQC11	CHAR	1	0	iSeries: Table field is nullable
9	UPDATES	☐	UPDATES	QQC11	CHAR	1	0	iSeries: Table field is updatable
10	REMARKS	☐	REMARKS	QQ1000	CHAR	255	0	iSeries: Long comment of a table, view or table field
11	Q_DEFAULT	☐	HASDEFAULT	QQC11	CHAR	1	0	iSeries: Table field has default
12	Q_LABEL	☐	COL_LABEL	FDNAME	CHAR	30	0	iSeries: Table field column heading	*
13	STORAGE	☐	STORAGE	QINT4	INT4	10	0	iSeries: Table field storage requirement
14	QPRECISION	☐	PRECISION	QINT4	INT4	10	0	iSeries: Table field numeric precision
15	Q_CCSID	☐	CCSID	QINT4	INT4	10	0	iSeries: Table field CCSID
16	DBNAME	☐	TAB_SCHEMA	QQTLN	CHAR	10	0	iSeries: SQL schema name of table or view
17	DFTVALUE	☐	DFTVALUE	QCHAR10	CHAR	10	0	iSeries: Table field default value
18	CHARLEN	☐	CHARLEN	QINT4	INT4	10	0	iSeries: Maximum length of a character column
19	CHARBYTE	☐	CHARBYTE	QINT4	INT4	10	0	iSeries: Table field no. of character bytes
20	RADIX	☐	RADIX	QINT4	INT4	10	0	iSeries: Table field RADIX, precision of numeric fie
21	DATPRC	☐	DATPRC	QINT4	INT4	10	0	iSeries: Table fields date/time precision
22	LABELTEXT	☐	LABELTEXT	QCHAR10	CHAR	10	0	iSeries: Table field lable text
23	SYS_CNAME	☐	SYS_CNAME	QCHAR10	CHAR	10	0	iSeries: iSeries system column name
24	SYS_TNAME	☐	SYS_TNAME	QCHAR10	CHAR	10	0	iSeries: iSeries system name of table or view
25	SYS_DNAME	☐	SYS_DNAME	QCHAR10	CHAR	10	0	iSeries: iSeries system name of table/view schema

History

Last changed by/on	SAP	20070813
SAP Release Created in