Go to the bottom.
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name: NPCONSTRAINT.SDDL
!
! Purpose: This SDDL file defines the npconstraint relation.
!
! Modification History:
!
! Date OPR Who Reason
! -------- ------- --- -------------------------------------------------
! 10/28/94 27329 MRB Original implementation
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!
LANGUAGE FORTRAN, SQL
INCLUDE ZSPSS_USER_TYPES.SDDL
RECORD NPCONS_TYPE
!------------------------------------------------------------------------------
!
! RECORD INFORMATION
!
!------------------------------------------------------------------------------
DESCRIPTION "This relation holds constraint text describing
constraints applied during SMS Precedence Checking.
These data are for the user's notes regarding the
different constraints defined for the precedence
checker. The text has no impact on the checker.
See NPNAMES_TABLE to understand where this data comes
from and how it is used. The description for
NPNAMES_TABLE also has a complete list of the related
precedence checker relations. Also refer to Chapters 22
through 33 of the SCS User's Guide for more information
on the precedence checker."
!------------------------------------------------------------------------------
!
! FIELD INFORMATION
!
!------------------------------------------------------------------------------
FIELD cnstrnt_id
TYPE C12
DESCRIPTION "This field is the constraint identifier which will
be used to identify all records related to this
constraint."
END_FIELD
FIELD page_no
TYPE COMMENT_PAGE_TYPE
DESCRIPTION "This field is the page number for the text.
A maximum of two pages may be entered."
END_FIELD
FIELD line1
TYPE COMMENT_LINE_TYPE
DESCRIPTION "This field is the constraint text or comments."
END_FIELD
FIELD line2
TYPE COMMENT_LINE_TYPE
END_FIELD
FIELD line3
TYPE COMMENT_LINE_TYPE
END_FIELD
FIELD line4
TYPE COMMENT_LINE_TYPE
END_FIELD
FIELD line5
TYPE COMMENT_LINE_TYPE
END_FIELD
FIELD line6
TYPE COMMENT_LINE_TYPE
END_FIELD
FIELD line7
TYPE COMMENT_LINE_TYPE
END_FIELD
FIELD line8
TYPE COMMENT_LINE_TYPE
END_FIELD
FIELD line9
TYPE COMMENT_LINE_TYPE
END_FIELD
FIELD line10
TYPE COMMENT_LINE_TYPE
END_FIELD
FIELD line11
TYPE COMMENT_LINE_TYPE
END_FIELD
FIELD line12
TYPE COMMENT_LINE_TYPE
END_FIELD
FIELD line13
TYPE COMMENT_LINE_TYPE
END_FIELD
FIELD line14
TYPE COMMENT_LINE_TYPE
END_FIELD
FIELD line15
TYPE COMMENT_LINE_TYPE
END_FIELD
FIELD line16
TYPE COMMENT_LINE_TYPE
END_FIELD
FIELD line17
TYPE COMMENT_LINE_TYPE
END_FIELD
FIELD line18
TYPE COMMENT_LINE_TYPE
END_FIELD
FIELD line19
TYPE COMMENT_LINE_TYPE
END_FIELD
FIELD line20
TYPE COMMENT_LINE_TYPE
END_FIELD
FIELD line21
TYPE COMMENT_LINE_TYPE
END_FIELD
FIELD line22
TYPE COMMENT_LINE_TYPE
END_FIELD
FIELD line23
TYPE COMMENT_LINE_TYPE
END_FIELD
FIELD line24
TYPE COMMENT_LINE_TYPE
END_FIELD
END_RECORD
!------------------------------------------------------------------------------
!
! RELATION DECLARATION
!
!------------------------------------------------------------------------------
RELATION npconstraint
TYPE NPCONS_TYPE
DESCRIPTION "Precedence Checker Constraint Text Relation"
SUBSYSTEM_USING "SCS"
RELATED_FIELDS "npnames.*" "npincp_list.cnstrnt_id" "npstate_trn.cnstrnt_id" "nptrnslation.cnstrnt_id"
INDEX npconstraint_1
TYPE unique, clustered
FIELDS cnstrnt_id, page_no
END_INDEX
END_RELATION
!------------------------------------------------------------------------------
!
! INSTANCE DECLARATION
!
!------------------------------------------------------------------------------
INSTANCE npconstraint
GLOBAL
TYPE NPCONS_TYPE
END_INSTANCE
Go to the top.