Possible SQL Results

When you execute SQL statements with the methods of the sdb.sql module, you get different results depending on the type of SQL statement executed.

SQL Statement

Result

SELECT

An object of the class SapDB_ResultSet

UPDATE, DELETE

Number of changed or deleted data records

INSERT

?     Object of the class SapDB_Result if the table into which the data records are inserted contains a column of type SERIAL

?     Number of inserted records if the table into which the data records are inserted contains no column of type SERIAL

CALL

?     Output parameters
if the database procedure (stored procedure) returns output parameters

?     Object of the class SapDB_ResultSet
if the database procedure returns a result set

?     Object of the class SapDB_Result
if the database procedure returns output parameters and a result set

DDL (Data Definition Language)

None