ALLBASE/SQL Reference Manual (36216-90216)

Chapter 10 297
SQL Statements A - D
ADVANCE
ADVANCE
The ADVANCE statement is a procedure cursor manipulation statement. It is used in
conjunction with procedures having one or more multiple row result sets to advance the
position of an opened procedure cursor to the first or next query result set and to initialize
information in the associated sqlda_type and sqlformat_type data structures.
Scope
Application Programs Only
SQL Syntax
ADVANCE CursorName [USING [SQL]DESCRIPTOR {SQLDA
AreaName }]
Parameters
CursorName identifies a procedure cursor. The procedure cursor's
current active query result set, the procedure's
statements, and the values of any procedure input
parameters, determine the format information to be
returned by each successive ADVANCE statement.
USING [SQL] DESCRIPTOR defines where to place the data format information of a
query result for an EXECUTE PROCEDURE statement on
which a procedure cursor has been defined. Specify a
location that does not conflict with that of another SQL
statement such as OPEN, CLOSE, DESCRIBE, EXECUTE,
or any FETCH that is not associated with this ADVANCE
statement.
SQLDA specifies that a data structure of sqlda_type named
SQLDA is to be used to pass information about the next
result set between the application and ALLBASE/SQL.
AreaName specifies the user defined name of a data structure of
sqlda_type that is to be used to pass information about the
next result set between the application and
ALLBASE/SQL.
Description
• The query result set to which the procedure cursor points is called the active result set.
You use the information in the associated sqlda_type and sqlformat_type data
structures to process the query result set via FETCH statements.
• For a procedure that returns multiple row results of a single format, if the procedure
was created with the WITH RESULT clause, it is unnecessary to issue an ADVANCE
statement to get format information for each result set, since the format is already