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 |
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.