Go to the bottom.

!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:	PDB_TAPE_ID.SDDL
!
! Purpose:      This SDDL file defines the pdb_tape_id relation.
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ---   -------------------------------------------------
! 11/ 2/94    27329     EGB   Original implementation
! 12/14/94    27329     NLC   Add instance declaration
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!

LANGUAGE	FORTRAN, SQL

INCLUDE         ZSPSS_USER_TYPES.SDDL

RECORD  PDBID_TYPE

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

    DESCRIPTION       "This relation contains a list of different versions
		       of the PDB that have been loaded into the PMDB.  Every
		       time a new PDB is installed operationally, a record will 
		       be appended to this relation that will identify the name 
		       of the PDB and the time it was installed operationally.

		       Many of the PMDB relations have a common index field 
		       called pdb_tape_id that enables multiple versions of
		       the PDB to be stored operationally at a given instance 
		       in time.  Note that only the current PDB is stored in 
		       these database tables at any given time."

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



    FIELD  pdb_tape_id
        TYPE PDB_ID_TYPE
    END_FIELD


    FIELD  append_date
        TYPE TIME_STAMP_TYPE
        DESCRIPTION     "This field is set to the time the PDB was installed 
			 into the PMDB.  You can determine what the current PDB 
			 is by getting the record with the latest date from
			 this table."
    END_FIELD

END_RECORD

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

RELATION  pdb_tape_id

    TYPE             PDBID_TYPE

    DESCRIPTION      "Project Database Identifier Relation"

    SUBSYSTEM_USING  "SPSS", "SCS", "SCIOPSDB"

    RELATED_FIELDS  "qginstruct.pdb_tape_id" "qxpdbcon.pdb_tape_id" "widcr_parms.pdb_tape_id"


    INDEX pdb_tape_id_1
        TYPE    unique, clustered
        FIELDS  pdb_tape_id
    END_INDEX
		
END_RELATION

!------------------------------------------------------------------------------
!
!   INSTANCE DECLARATION
!
!------------------------------------------------------------------------------
 
INSTANCE  pdb_tape_id
 
    GLOBAL
 
    TYPE        PDBID_TYPE
 
END_INSTANCE

Go to the top.