QADBFCST - File Constraint Cross Reference

Columns Listing
QSYS/QADBFCST
Name	Type	Len	Prec	Scale	Nulls?	Description
DBCCFL	Char	10			N	Constraint file library
DBCCFF	Char	10			N	Constraint file name
DBCCTY	Char	11			N	CHECK, FOREIGN KEY, PRIMARY KEY, UNIQUE
DBCDFR	Char	3			N	Constraint deferrable: NO
DBCIDF	Char	3			N	Constraint initially deferrable: NO
DBCCNL	Char	10			N	Constraint library name
DBCCNM	Char	128			N	Constraint name
DBCCND	Char	1			N	Delimiters required? Y-Yes, N-No
DBCTMS	Timestamp				N	Timestamp the constraint was defined
DBCNCK	Small Integer		5		Y	Number of key fields, null if CHECK
DBCPFL	Char	10			Y	Parent library name, null if not FOREIGN KEY
DBCPFF	Char	10			Y	Parent file name, null if not FOREIGN KEY
DBCRMC	Char	7			Y	NONE, null if not FOREIGN KEY
DBCRDR	Char	11			Y	CASCADE,NO ACTION,SET NULL,SET DEFAULT,RESTRICT
DBCRUR	Char	11			Y	NO ACTION or null if not FOREIGN KEY
DBCUNM	Char	128			Y	Unique or primary CST, null if not FOREIGN KEY
DBCUND	Char	1			Y	Delimiters required? Y-Yes, N-No
DBCULB	Char	10			Y	Unique constraint library, null if not FOREIGN KEY
DBCCDN	Char	###			Y	Check constraint defintion name, null if not CHECK
DBCCLC	Char	###			Y	Long constraint defintion
DBCSTA	Char	1			Y	FOREIGN KEY constraint status: V-Valid N-Not Valid
DBCCN2	Char	128			N	Constraint file library
DBCUL2	Char	128			Y	Unique constraint library, null if not FOREIGN KEY