The RELEASE (Connection) statement places one or more connections in the release-pending state.
Although an interactive SQL facility might provide an interface that gives the appearance of interactive execution, this statement can only be embedded within an application program. It is an executable statement that cannot be dynamically prepared.
None required.
(1) >>-RELEASE--+-server-name-----+-------------------------------->< +-host-variable---+ +-CURRENT---------+ | .-SQL-. | '-ALL--+-----+----'
If a host-variable is specified, it must be a character string variable with a length attribute that is not greater than 8, and it must not include an indicator variable. The server-name that is contained within the host-variable must be left-aligned and must not be delimited by quotation marks.
Note that the server-name is a database alias identifying the application server. It must be listed in the application requester's local directory.
The specified database-alias or the database-alias contained in the host variable must identify an existing connection of the application process. If the database-alias does not identify an existing connection, an error (SQLSTATE 08003) is raised.
EXEC SQL RELEASE IBMSTHDB;
EXEC SQL RELEASE CURRENT;
EXEC SQL RELEASE ALL;