16.20 - History Window Columns - Teradata SQL Assistant

Teradata® SQL Assistant for Windows User Guide

Product
Teradata SQL Assistant
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2020-01-03
dita:mapPath
gfk1537201040714.ditamap
dita:ditavalPath
ft:empty

The following table 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 dialog.

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.
  • 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.
  • Row columns functionality:
    • Teradata: 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: The Rows column still reports only the number of rows returned.