The Columns of the History Window - SQL Assistant

The Columns of the History Window

Table 29 lists the columns that appear in the History window.

If the Query text is longer than 1000 characters, it is truncated to 1000, and followed by ellipses (…). To view the entire text either click on it (to copy it to the Query window) or use the Edit History screen.

Table 29: The History Window Column Descriptions 

Column Name	Description
Date/Time	The date and time at which the query ended.
Source	The data source name used.
Elapsed	The total elapsed time for the query.
Rows	Teradata only: The number of rows matching the query submitted. Other databases: The number of rows returned or changed. See the second note below.
Result	The result message. See the first note below.
Notes	The note the user attached to the query.
SQL Statement	The query text.
SQL Type	The type of database accessed.
Length	The length of the query, in characters.
Stmts	The number of statements in the query.
Stmt Type	A list of statement types used in the query. For example, CREATE TABLE, INSERT, SELECT.
User ID	The user ID logged on.
DBMS Time	The time spent within the database.
Fetch Time	The time taken to return the data.
Seq (sequence)	The order the query was submitted to the database.

Note: The History grid displays a Result column instead of the full SqlMessage information. This column is blank unless an error occurred. To see the full Result message, position the mouse so that the cursor is over the Result cell.

Note: For Teradata systems only, if you abort a query in progress or decline to continue when the output limit is reached, the Rows column tells you how many rows matched the query you submitted rather than the number of rows that were actually returned to the PC. Other databases still report only the number of rows returned.