Go to the bottom.

!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:	SOGS_RELEASE.SDDL
!
! Purpose:      This SDDL file defines the sogs_release relation.
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ---   -------------------------------------------------
! 11/ 2/94    27329     EGB   Original implementation
! 01/15/96    30650     EGB   Rework for OPUS / SPSS decoupling
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!

LANGUAGE	SQL

RECORD  SOGSREL_TYPE

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

    DESCRIPTION       "This relation contains a history of SOGS database 
		       installations.  It is useful for determining the
                       build configuration of a SOGS 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 contains both OPUS and SPSS release 
		       information and 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 26929 for more details, and OPR
		       30650 for additional details."

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


    FIELD  opus_release_id
        TYPE            C*10
        DESCRIPTION     "This field identifies tha latest OPUS release 
			 to update the SOGS database.

                         Sample values include:  4.0, 5.0"
    END_FIELD


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


    FIELD  spss_release_id
        TYPE            C*10
        DESCRIPTION     "This field identifies tha latest SPSS release 
			 to update the SOGS 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 SOGS PMDB 
			 database was installed with SPSS-specific updates."
    END_FIELD

END_RECORD

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

RELATION  sogs_release

    TYPE             SOGSREL_TYPE

    DESCRIPTION      "SOGS Project Management Database Identifier Relation"

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

    INDEX sogs_release_1       
        TYPE    unique, clustered 
        FIELDS  opus_release_id, opus_install_date, 
		spss_release_id, spss_install_date
    END_INDEX

END_RELATION


Go to the top.