RELEASE (+, DB-Access, ESQL/C)

>>-RELEASE--+-'family_name'---------------+--volume_number-----><
            |                      (1)    |
            +-family-name variable--------+
            |                        (2)  |
            '-procedurename variable------'

Notes:

ESQL/C Only
SPL Only

Element	Purpose	Restrictions	Syntax
family_name	A quoted-string constant that specifies a family name in the optical-storage subsystem	Must be an existing family name.	Quoted String segment; see the IBM Informix: Guide to SQL Syntax.
family-name variable	A CHARACTER or VARCHAR host variable that contains a family name	Must be an existing variable name.	Variable name must conform to language-specific rules for variable names.
procedure-name variable	The name of a variable defined in an SPL routine	Must be defined in the procedure and valid in the statement block.	Identifier segment; see the IBM Informix: Guide to SQL Syntax.
volume_ number	The volume being released; specified as an integer	Must be reserved and mounted correctly.	Number must be an integer.

Each time that a RELEASE statement is executed, the value 1 is subtracted from the reserve counter for the volume. When the value of the reserve counter is zero, you can unmount the volume.

The volume specified in the RELEASE statement must be reserved and the platter that contains the volume must be mounted currently. An error is returned if the platter is not mounted or if the value of the reserve counter for the volume is zero.

You can issue multiple reserve requests, but you must release each one before you can remove the volume from the optical drive.

The following example releases a reservation for volume 013 in the catalog_1991 optical family:

RELEASE 'catalog_1991' 013

RELEASE (+, DB-Access, ESQL/C)

Syntax

Usage

Related Information