Go to the bottom.

!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:	LOCKS_WGACQUIS.SDDL
!
! Purpose:      This SDDL file defines the locks_wgacquis relation.
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ---   -------------------------------------------------
! 10/27/95   29724      NLC   Original implementation
! 10/01/01   44572      sss   Added index
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!
 
LANGUAGE	C, SQL

INCLUDE 	ZSPSS_USER_TYPES.SDDL

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

   DESCRIPTION    "This is the relation used to implement locking for the
		   WGACQUIS relation.  Only 1 record is written to this 
                   table.  

                   Processes which want a lock on the WGACQUIS table will
                   call a locking routine, which will update this relation.
                   The process will release the lock after it has completed
                   all updates to the WGACQUIS table.  No other processes 
                   will be allowed to update this relation until the lock 
                   is released; thus, access to the WGACQUIS table 
                   is serialized. "

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

    FIELD  lock_field
        TYPE LOCK_FIELD_TYPE
	DESCRIPTION	"This field is used for updating the locks_wgacquis
			 table.  It's value does not matter."
    END_FIELD

END_RECORD

!------------------------------------------------------------------------------
!
!   RELATION DECLARATION
!
!------------------------------------------------------------------------------
 
RELATION  locks_wgacquis
 
    TYPE             LCKWGACQ_TYPE
 
    DESCRIPTION      "Wgacquis Locking Relation"
 
    SUBSYSTEM_USING  "SPSS"
 
    RELATED_FIELDS  "wgacquis.*" "locks_wgrequests.*" "locks_wprsu_retlis.*" "locks_wresp.*"

                     
    INDEX  locks_wgacquis_1
        TYPE         clustered
        FIELDS       lock_field
    END_INDEX

END_RELATION
 
!------------------------------------------------------------------------------
!
!   INSTANCE DECLARATION
!
!------------------------------------------------------------------------------
 
 
INSTANCE  wgacquis_locks
 
    GLOBAL
 
    TYPE        LCKWGACQ_TYPE
 
END_INSTANCE

Go to the top.