ALLBASE/SQL Reference Manual (36216-90216)

Chapter 10 287
SQL Statements A - D
SQL Statement Summary
BULK INSERT Inserts multiple rows into a single
table. (See INSERT.)
BULK SELECT Retrieves multiple rows not
associated with a cursor. (See
SELECT.)
Cursor management
ADVANCE Advances a procedure cursor.
CLOSE Closes a cursor currently in the
open state.
DECLARE CURSOR Associates a cursor with a specific
SELECT or EXECUTE PROCEDURE
statement.
DELETE WHERE CURRENT Deletes the current row of an active
set.
FETCH Advances the position of an open
cursor to the next row of the active
set and copies columns into host
variables.
REFETCH Copies columns from the current
cursor position in the active set into
host variables. Used with the RU
and RC isolation levels to verify the
continued existence of data and to
obtain stronger locks prior to
updating.
OPEN Makes an active set available to
manipulation statements.
UPDATE WHERE CURRENT Changes columns in the current row
of the active set.
Preprocessor directives
BEGIN DECLARE
SECTION
Indicates the beginning of the host
variable declarations in an
application program.
END DECLARE SECTION Indicates the end of the host
variable declarations in an
application program.
INCLUDE Includes declarations for structures
used to pass information between
ALLBASE/SQL and a program.
Table 10-1. SQL Statement Summary
Group Category Statement Statement Use