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.