CLOSE (BLOB)

Go Up to Statement and Function Reference (Language Reference Guide)

Terminates a specified Blob cursor and releases associated system resources. Available in gpre.

 CLOSE <blob_cursor>;

Argument	Description
<blob_cursor>	Name of an open Blob cursor

Description: CLOSE closes an opened read or insert Blob cursor. Generally a Blob cursor should be closed only after:

• Fetching all the Blob segments for BLOB READ operations.
• Inserting all the segments for BLOB INSERT operations.

Example: The following embedded SQL statement closes a Blob cursor:

EXEC SQL
CLOSE BC;

See Also

• DECLARE CURSOR (BLOB)
• FETCH (BLOB)
• INSERT CURSOR (BLOB)
• OPEN (BLOB)

Advance To:

• COALESCE( )