DTRHELP.HLB  —  Commands Statements Clauses, RELEASE Command
       Ends your control over one or more collections, forms, tables, or
       global variables and frees the workspace occupied by them.

       Format

                  [ ALL             ]
                  [ collection-name ]
         RELEASE  [ form-name       ]  [,...]
                  [ table-name      ]
                  [                 ]
                  [ variable-name   ]

1  –  Arguments

    ALL

       Causes DEC DATATRIEVE to release all collections, tables, or
       variables.

    form-name

       Is the name of a form, a collection, a dictionary or domain
       table, or a variable you want to release. If you specify more
       than one item, use a comma to separate each from the next.

2  –  Examples

       The following example releases first one of two named
       collections, then the other:

       DTR> SHOW COLLECTIONS
       Collections:
              BIG-ONES         (CURRENT)
              A

       DTR> RELEASE BIG-ONES
       DTR> SHOW COLLECTIONS
       Collections:
              A                (CURRENT)

       DTR> RELEASE A
       DTR> SHOW COLLECTIONS
       No established collections.
       DTR>

       The following example releases the dictionary table DEPT-TABLE
       and the global variables X and Y:

       DTR> SHOW READY
       No ready sources.

       Loaded tables:
          DEPT_TBL:  Dictionary table
                  <CDD$TOP.WORK.DEPT_TBL>

       DTR> SHOW VARIABLES
       Global variables
          X                    <Character string>
          Declared as: X REAL MISSING VALUE IS 36.

          Y                    <Character string>
          Declared as: Y PIC X(9).

       DTR> RELEASE DEPT_TBL, X, Y

       DTR> SHOW READY; SHOW VARIABLES
       No ready sources.
       No loaded tables.
       No global variables are declared.
       DTR>

       The following example uses the RELEASE ALL command to release the
       collections LITTLE_ONES and B, and also the global variables T
       and TERRY:

       DTR> SHOW COLLECTIONS
       Collections:
              B                (CURRENT)
              LITTLEONES

       DTR> SHOW VARIABLES
       Global variables
          T                    <Date>
          Declared as: T DATE.

          TERRY                <Character string>
          Declared as: TERRY PIC X(9).

       DTR> RELEASE ALL
       DTR> SHOW COLLECTIONS
       No established collections.

       DTR> SHOW VARIABLES
       No global variables are declared.

       DTR>
Close Help