 |
» |
|
|
|
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 known from the DESCRIBE RESULT statement. The ADVANCE statement cancels any current, active query result set.
It can be used as an efficient way to throw away any unread rows
resulting from the most recently executed multiple row result set
SELECT statement in the procedure. The execution of the procedure
continues with the next statement. Control returns to the application when
the next multiple row result set statement is executed, or when
procedure execution terminates. Refer to the ALLBASE/SQL Advanced Application
Programming Guide for further explanation and examples
of how to use the ADVANCE statement.
Authorization | |
You do not need authorization to use the ADVANCE statement. Example | |
Refer to the ALLBASE/SQL Advanced Application Programming
Guide for a pseudocode example of procedure cursor usage. |
