From 6eb9c5a5657d1fe77b55cc261450f3538d35a94d Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 14:19:15 +0200 Subject: Adding upstream version 13.4. Signed-off-by: Daniel Baumann --- doc/src/sgml/html/ecpg-sql-open.html | 31 +++++++++++++++++++++++++++++++ 1 file changed, 31 insertions(+) create mode 100644 doc/src/sgml/html/ecpg-sql-open.html (limited to 'doc/src/sgml/html/ecpg-sql-open.html') diff --git a/doc/src/sgml/html/ecpg-sql-open.html b/doc/src/sgml/html/ecpg-sql-open.html new file mode 100644 index 0000000..9400f4f --- /dev/null +++ b/doc/src/sgml/html/ecpg-sql-open.html @@ -0,0 +1,31 @@ + +OPEN
OPEN
Prev Up35.14. Embedded SQL CommandsHome Next

OPEN

OPEN — open a dynamic cursor

Synopsis

+OPEN cursor_name
+OPEN cursor_name USING value [, ... ]
+OPEN cursor_name USING SQL DESCRIPTOR descriptor_name
+

Description

+ OPEN opens a cursor and optionally binds + actual values to the placeholders in the cursor's declaration. + The cursor must previously have been declared with + the DECLARE command. The execution + of OPEN causes the query to start executing on + the server. +

Parameters

cursor_name

+ The name of the cursor to be opened. This can be an SQL + identifier or a host variable. +

value

+ A value to be bound to a placeholder in the cursor. This can + be an SQL constant, a host variable, or a host variable with + indicator. +

descriptor_name

+ The name of a descriptor containing values to be bound to the + placeholders in the cursor. This can be an SQL identifier or + a host variable. +

Examples

+EXEC SQL OPEN a;
+EXEC SQL OPEN d USING 1, 'test';
+EXEC SQL OPEN c1 USING SQL DESCRIPTOR mydesc;
+EXEC SQL OPEN :curname1;
+

Compatibility

+ OPEN is specified in the SQL standard. +

See Also

DECLARE, CLOSE
Prev Up Next
GET DESCRIPTOR Home PREPARE
\ No newline at end of file -- cgit v1.2.3