Success Response | SQL Fundamentals | Teradata Vantage - Success Response - Advanced SQL Engine - Teradata Database

SQL Fundamentals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
zwv1557098532464.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1141
lifecycle
previous
Product Category
Teradata Vantageâ„¢

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.

An activity count is meaningful for statements that return a result set, for example:
  • SELECT
  • INSERT
  • UPDATE
  • DELETE
  • HELP
  • MERGE
  • SHOW
  • EXPLAIN
  • 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