Previous Topic: CASE StatementNext Topic: Description


CLOSE

This SQL statement can be executed in the following ways:

Through the CA Datacom Datadictionary Interactive SQL Service Facility (interactive)

In an application program prepared using a CA Datacom/DB SQL Preprocessor (embedded)

By using CA Dataquery (SQL & Batch Modes)

CLOSE

 

YES

 

Note: YES indicates a valid execution method for this statement. For information about the access rights required to execute this statement, see the CA Datacom/DB Database and System Administration Guide.

The CLOSE statement closes a cursor. If a temporary table is created when the cursor is opened, the table is destroyed when the cursor is closed.

Following is the syntax diagram for the CLOSE statement:

►►─ CLOSE ─ cursor-name ──────────────────────────────────────────────────────►◄