OPEN (BLOB)

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

Opens a previously declared Blob cursor and prepares it for reading or inserting. Available in gpre.

OPEN [TRANSACTION name] cursor 
{INTO | USING} :blob_id;

Argument	Description
TRANSACTION <name>	Specifies the transaction under which the cursor is opened Default: The default transaction
<cursor>	Name of the Blob cursor
INTO | USING	Depending on Blob cursor type, use one of these: INTO: For INSERT BLOB USING: For READ BLOB
<blob_id>	Identifier for the Blob column

Description: OPEN prepares a previously declared cursor for reading or inserting Blob data. Depending on whether the DECLARE CURSOR statement declares a READ or INSERT BLOB cursor, OPEN obtains the value for Blob ID differently:

• For a READ BLOB, the <blob_id> comes from the outer TABLE cursor.
• For an INSERT BLOB, the <blob_id> is returned by the system.

Examples: The following embedded SQL statements declare and open a Blob cursor:

EXEC SQL
DECLARE BC CURSOR FOR
INSERT BLOB PROJ_DESC INTO PRJOECT;
EXEC SQL
OPEN BC INTO :blob_id;

See Also

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