DECLARE

Defines a new cursor within an SAP work process and assigns the SQL statement to this. The short form of this statement is displayed in the list of the trace records under Statement. The cursor is given a unique number, the cursor ID. The cursor ID is used for communication between the SAP System and the database system.

PREPARE

Converts the SQL statement and defines the execution plan.

OPEN

Opens a cursor for a prepared (converted) SELECT statement. OPEN passes the parameters for the database access. OPEN is used only for SELECT statements.

FETCH

Passes one or several records selected from the database through the SELECT statement to the DB interface of the SAP System. The selected data is identified through the cursor.

REOPEN

Opens again a cursor that the system has prepared for a SELECT statement and passes the new parameters to the database.

EXEC

Transfer of the parameters for the statement from the database and execution of the statement that change data in the database (for example, using UPDATE, DELETE, or INSERT).

REEXEC

Opens again a cursor that the system has already prepared for a previous EXEC statement.