SQL Programming Manual for TAL

Dynamic NonStop SQL Operations
HP NonStop SQL Programming Manual for TAL—527887-001
7-33
Using Statement and Cursor Host Variables
Using Statement and Cursor Host Variables
TAL supports using statement and cursor host variables in dynamic SQL operations.
You can use host variables instead of statement and cursor names, with the DECLARE
CURSOR, PREPARE, OPEN, FETCH, and CLOSE statements. For each new
statement or cursor name, you store the name in the host variable before executing the
statements. Thus, you must code the statements only once.
The example program in Figure 7-6
shows one method to use statement and cursor
host variables.