History Preferences - Teradata Studio

Teradata Studio IDE Plug-in User Guide

Product
Teradata Studio
Release Number
16.00
Published
March 2017
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
poj1484765174891.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2043
Product Category
Teradata Tools and Utilities

Exclude Options for History Database

Select one or more of these options to exclude in the Teradata SQL History database:
Option Description
Exclude Explain Statements Check this box to exclude EXPLAIN statements in the History database.
Exclude Unsuccessful Queries Check this 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 see full message, hover your mouse over a cell in the Result column.
Row Count
  • Teradata Database — number of rows matching the query submitted. If you abort a query in progress or decline to continue after the output limit is reached, Rows shows only how many rows matched the query you submitted.
  • Other databases — number of rows returned or changed. If you abort, Rows shows only the number of rows returned.
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

Actions

Option Description
Apply Click to apply your changes.
Restore Defaults Click to return settings to default values.
OK Click to save your preference settings.