When to use the different ITQuery methods

This section describes how to use the HCL Informix® Object Interface for C++ query methods appropriately.

The ExecForStatus method
Use the ExecForStatus method of the Query object for queries when the application does not need any data returned from the query (for example, DDL statements such as CREATE TABLE, DROP TABLE, CREATE VIEW, or DML statements such as UPDATE).
The ExecOneRow method
Use the ExecOneRow method of the Query object for queries that return (or are expected to return) one row.
The ExecToSet method
Use the ExecToSet method of the Query object for queries that return more than one row.
The ExecForIteration method
Use the ExecForIteration method of the Query object for queries that return a large result set that must be processed a row at a time.

Parent topic: Issue queries