Exclude Options for History Database
| Option | Description |
|---|---|
| Exclude Explain and Dynamic Explain Statements | Select the check box to exclude EXPLAIN and DYNAMIC EXPLAIN statements in the History database. |
| Exclude Unsuccessful Queries | Select the check box to exclude unsuccessful queries from being entered in the History database. |
History Options
| Option | Description |
|---|---|
| Limit History View Rows | Enter the maximum number of rows allowed to display in the Teradata SQL History view. |
| Maximum Text Display Length | Enter the maximum number of characters that can be displayed in a row. |
| Derby Database Location | Displays the location of the SQL history file. To change the location, click Browse and navigate to the desired location. |
History View Columns Settings
Use action buttons to select and move columns between the Columns Shown panel and the Removed Columns panel.
| Column Actions | Description |
|---|---|
| Remove | Removes the column you select from the Columns Shown list. |
| Remove All | Removes all columns shown in the Columns Shown list. |
| Add | Moves a column from the Removed Columns list to the Columns Shown list. |
| Add All | Adds all columns in the Removed Columns list to the Columns Shown list. |
| Up | Moves a selected column one position up in the list. |
| Down | Moves a selected column down one position in the list. |
| Column Options | Description |
|---|---|
| Timestamp | Date and time at which the query ended |
| Source | Data source name |
| User ID | User ID logged on |
| Destination | TBW - in progress |
| Result | Result message which is blank unless an error occurs. To view the complete message, hover your mouse over a cell in the Result column. |
| Row Count |
|
| Note | User note attached to query |
| SQL Statement | Query text |
| SQL Type | Type of database accessed |
| Length | Length of the query in characters |
| Statements | Number of statements in the query |
| Statement Type | List of statement types used in the query, such as, CREATE TABLE, INSERT, SELECT |
| Elapsed Time | Total elapsed time for the query |
| DBMS Time | Time spent within the database |
| Fetch Time | Time taken to return the data |
| Parameters | Number of parameters used in the query |
| Sequence | Order in which the query was submitted to the database |