A success response contains an activity count that indicates the total number of rows involved in the result.
For example, the activity count for a SELECT statement is the total number of rows selected for the response. For a SELECT, CALL (when the stored procedure or external stored procedure creates result sets), COMMENT, or ECHO statement, the activity count is followed by the data that completes the response.
- CREATE PROCEDURE
- REPLACE PROCEDURE
- CALL(when the stored procedure or external stored procedure creates result sets)
For other SQL statements, activity count is meaningless.
Example: Using an Interactive SELECT Statement
The following interactive SELECT statement returns the successful response message.
SELECT AVG(f1) FROM Inventory; *** Query completed. One row found. One column returned. *** Total elapsed time was 1 second. Average(f1) ----------- 14