Background documentationPossible SQL Results Locate this document in the navigation structure

 

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

SQL Statement

Result

SELECT

Object of the SapDB_ResultSet class (sdb.sql module)

UPDATE, DELETE

Number of changed or deleted data records

INSERT

  • If the table in which the data records are inserted contains a column of the SERIAL type: object of the SapDB_Result class (sdb.sql module)

  • If the table in which the data records are inserted does not contain a column of the SERIAL type: number of inserted records

CALL

  • If the database procedure (stored procedure) returns output parameters: output parameters

  • If the database procedure returns a result set: object of the SapDB_ResultSet class

  • If the database procedure returns both output parameters and a result set: object of the SapDB_Result class

DDL (Data Definition Language)

None