SAP ABAP Table QSYSKEYS (iSeries: System Catalog View of Constraints Columns)

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	QSYSKEYS	Table Relationship Diagram
Short Description	iSeries: System Catalog View of Constraints Columns

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	IDX_NAME	☐	IDX_NAME	DBINDEX	CHAR	18	0	iSeries: SQL index name
2	IXCREATOR	☐	IXCREATOR	QCHAR10	CHAR	10	0	iSeries: Owner of index
3	COLNAME	☐	COL_NAME	FDNAME	CHAR	30	0	iSeries: SQL column name	*
4	COL_POS	☐	ORD_POS	QINT4	INT4	10	0	iSeries: Ordinal position of field in the table
5	COL_SEQ	☐	COL_SEQ	INT4	INT4	10	0	iSeries: Position of column within the key/index
6	ORDERING	☐	ORDERING	QQC11	CHAR	1	0	iSeries: Order of the column in the index
7	IDX_SCHEMA	☐	IDX_SCHEMA	QQTLN	CHAR	10	0	iSeries: SQL schema name of index
8	SYS_CNAME	☐	SYS_CNAME	QCHAR10	CHAR	10	0	iSeries: iSeries system column name
9	SYS_IXNAME	☐	SYS_IXNAME	QCHAR10	CHAR	10	0	iSeries: iSeries system index name
10	SYS_IDNAME	☐	SYS_IDNAME	QCHAR10	CHAR	10	0	iSeries: iSeries system index schema name

History

Last changed by/on	SAP	20070813
SAP Release Created in