Processing results in a DB2 UDB CLI application

 

The next step after the statement has been processed depends on the type of SQL statement.

• Processing SELECT statements in a DB2 UDB CLI application
  If the statement is SELECT, these steps are generally needed to retrieve each row of the result set.

• Processing UPDATE, DELETE, and INSERT statements in a DB2 UDB CLI application
  If the statement modifies data (UPDATE, DELETE, or INSERT), no action is required other than the normal check for diagnostic messages. In this case, SQLRowCount() can be used to obtain the number of rows affected by the SQL statement.

• Processing other SQL statements in a DB2 UDB CLI application
  If the statement neither queries nor modifies data, there is no further action other than the normal check for diagnostic messages.

 

Parent topic:

Transaction processing task in a DB2 UDB CLI application