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>