ALLBASE/SQL Reference Manual (36216-90216)

298 Chapter10
SQL Statements A - D
ADVANCE
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.