Cursors and statement names in REXX
In REXX applications that contain SQL statements, you must use a predefined set of names for cursors or prepared statements.
The following names are valid for cursors and prepared
statements in REXX applications:
- c1 to c100
- Cursor names for DECLARE CURSOR, OPEN, CLOSE, and FETCH statements. By default, c1 to c100 are defined with the WITH RETURN clause, and c51 to c100 are defined with the WITH HOLD clause. You can use the ATTRIBUTES clause of the PREPARE statement to override these attributes or add additional attributes. For example, you might want to add attributes to make your cursor scrollable.
- c101 to c200
- Cursor names for ALLOCATE, DESCRIBE, FETCH, and CLOSE statements that are used to retrieve result sets in a program that calls a stored procedure.
- s1 to s100
- Prepared statement names for DECLARE STATEMENT, PREPARE, DESCRIBE, and EXECUTE statements.
Use only the predefined names for cursors and statements.
When you associate a cursor name with a statement name in a DECLARE
CURSOR statement, the cursor name and the statement must have the
same number. For example, if you declare cursor c1, you need to declare
it for statement s1:
EXECSQL 'DECLARE C1 CURSOR FOR S1'