SAP ABAP Table QSYSKEYCST (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	QSYSKEYCST	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	CDBNAME	☐	CS_SCHEMA	QQTLN	CHAR	10	0	iSeries: SQL schema name of a constraint
2	RELNAME	☐	RELNAME	DBINDEX	CHAR	18	0	iSeries: SQL constraint name
3	TDBNAME	☐	TAB_SCHEMA	QQTLN	CHAR	10	0	iSeries: SQL schema name of table or view
4	TBNAME	☐	TBNAME	AS4TAB	CHAR	30	0	iSeries: SQL Name of Table or View	*
5	COL_NAME	☐	COL_NAME	FDNAME	CHAR	30	0	iSeries: SQL column name	*
6	COL_SEQ	☐	COL_SEQ	INT4	INT4	10	0	iSeries: Position of column within the key/index
7	COL_POS	☐	ORD_POS	QINT4	INT4	10	0	iSeries: Ordinal position of field in the table
8	TBCREATOR	☐	TBCREATOR	QCHAR10	CHAR	10	0	iSeries: Owner of table or view
9	SYS_CNAME	☐	SYS_CNAME	QCHAR10	CHAR	10	0	iSeries: iSeries system column name
10	SYS_TNAME	☐	SYS_TNAME	QCHAR10	CHAR	10	0	iSeries: iSeries system name of table or view
11	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