Go to the bottom.
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:	QPABSTRACT.SDDL
!
! Purpose:      This SDDL file defines the qpabstract relation.
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ---   -------------------------------------------------
! 11/28/94    27329     EGB   Original implementation
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!
 
LANGUAGE	FORTRAN, SQL

INCLUDE         ZSPSS_USER_TYPES.SDDL
 
RECORD  QPABS_TYPE
 
!------------------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!------------------------------------------------------------------------------
 
 
    DESCRIPTION       "This relation contains a brief abstract of the 
		       proposal.  There can be multiple records or pages
		       of the abstract."

!------------------------------------------------------------------------------
!
!   FIELD INFORMATION
!
!------------------------------------------------------------------------------
 

    FIELD  proposal_id
        TYPE PROPOSAL_ID_TYPE
    END_FIELD
 

     FIELD  page_num
        TYPE COMMENT_PAGE_TYPE
    END_FIELD
 

    FIELD  abstract1
        TYPE COMMENT_LINE_TYPE
    END_FIELD
 

    FIELD  abstract2
        TYPE COMMENT_LINE_TYPE
    END_FIELD
 

    FIELD  abstract3
        TYPE COMMENT_LINE_TYPE
    END_FIELD
 

    FIELD  abstract4
        TYPE COMMENT_LINE_TYPE
    END_FIELD
 

    FIELD  abstract5
        TYPE COMMENT_LINE_TYPE
    END_FIELD
 

    FIELD  abstract6
        TYPE COMMENT_LINE_TYPE
    END_FIELD
 

    FIELD  abstract7
        TYPE COMMENT_LINE_TYPE
    END_FIELD
 

    FIELD  abstract8
        TYPE COMMENT_LINE_TYPE
    END_FIELD
 

    FIELD  abstract9
        TYPE COMMENT_LINE_TYPE
    END_FIELD
 

    FIELD  abstract10
        TYPE COMMENT_LINE_TYPE
    END_FIELD
 

    FIELD  abstract11
        TYPE COMMENT_LINE_TYPE
    END_FIELD
 

    FIELD  abstract12
        TYPE COMMENT_LINE_TYPE
    END_FIELD
 

    FIELD  abstract13
        TYPE COMMENT_LINE_TYPE
    END_FIELD
 

    FIELD  abstract14
        TYPE COMMENT_LINE_TYPE
    END_FIELD
 

    FIELD  abstract15
        TYPE COMMENT_LINE_TYPE
    END_FIELD
 

    FIELD  abstract16
        TYPE COMMENT_LINE_TYPE
    END_FIELD
 

    FIELD  abstract17
        TYPE COMMENT_LINE_TYPE
    END_FIELD
 

    FIELD  abstract18
        TYPE COMMENT_LINE_TYPE
    END_FIELD
 

    FIELD  abstract19
        TYPE COMMENT_LINE_TYPE
    END_FIELD
 

    FIELD  abstract20
        TYPE COMMENT_LINE_TYPE
    END_FIELD
 

    FIELD  abstract21
        TYPE COMMENT_LINE_TYPE
    END_FIELD
 

    FIELD  abstract22
        TYPE COMMENT_LINE_TYPE
    END_FIELD
 

    FIELD  abstract23
        TYPE COMMENT_LINE_TYPE
    END_FIELD
 

    FIELD  abstract24
        TYPE COMMENT_LINE_TYPE
    END_FIELD
 
END_RECORD
 
!------------------------------------------------------------------------------
!
!   RELATION DECLARATION
!
!------------------------------------------------------------------------------
 
 
RELATION  qpabstract
 
    TYPE             QPABS_TYPE
 
    DESCRIPTION      "Proposal Abstract Description Relation"
 
    SUBSYSTEM_USING  "SPSS", "TRANS"
 
    INDEX  qpabstract_1
        TYPE         unique, clustered
        FIELDS       proposal_id, page_num
    END_INDEX
 
END_RELATION
 
!------------------------------------------------------------------------------
!
!   INSTANCE DECLARATION
!
!------------------------------------------------------------------------------
 
INSTANCE  qpabstract
 
    GLOBAL
 
    TYPE        QPABS_TYPE
 
END_INSTANCE

Go to the top.