!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:	SPSS_RELEASE.SDDL
!
! Purpose:      This SDDL file defines the spss_release relation.
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ---   -------------------------------------------------
! 12/20/99    40250     sfs   Original implementation.
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!

LANGUAGE  C, SQL

RECORD    SPSSREL_TYP

!------------------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!------------------------------------------------------------------------------

    DESCRIPTION       "This relation contains a history of SPSS database 
		       installations.  It is useful for determining the
                       build configuration of an SPSS compatible database.

		       This was needed to help maintain the proliferation 
		       of test databases - it was often difficult to determine 
		       what configuration they were in (i.e. what build they 
                       map to). 

		       The table is designed to have only a single record
		       in it at any one time so a simple select will be
		       able to tell you the database configuration level.

                       See original OPR 40250 for more details."

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

    FIELD  spss_release_id
        TYPE            C*10
        DESCRIPTION     "This field identifies the latest SPSS release 
			 to update the SPSS database.

                         Sample values include:  35.7, 36.0"
    END_FIELD

    FIELD  spss_install_date
        TYPE            SYBASE_DATETIME  
        DESCRIPTION     "This field is set to the time the current SPSS PMDB 
			 database was installed with SPSS-specific updates."
    END_FIELD

END_RECORD

!------------------------------------------------------------------------------
!
!   RELATION DECLARATION
!
!------------------------------------------------------------------------------

RELATION  spss_release

    TYPE             SPSSREL_TYP

    DESCRIPTION      "SPSS Project Management Database Identifier Relation"

    SUBSYSTEM_USING  "SPSS", "SCS", "OPUS", "DBMS"

    INDEX spss_release_1       
        TYPE    unique, clustered 
        FIELDS  spss_release_id, spss_install_date
    END_INDEX

END_RELATION