Loading a Query from DBQL - System Emulation Tool

Teradata® System Emulation Tool User Guide

Product
System Emulation Tool
Release Number
17.10
Published
June 2021
Language
English (United States)
Last Update
2021-07-01
dita:mapPath
hdo1608578450920.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2492
lifecycle
previous
Product Category
Teradata Tools and Utilities
  1. Click DBQL Plans.
  2. In the Selection box, do one of the following.
    • Select DBQL (default) to browse XML queries from the DBQL.
    • Select External Database to browse XML queries from an external database.
  3. [Optional] Click DBQL Filter Options.
  4. Enter data in the Select Criteria dialog box.
    Option Description
    Step Count The minimum number of steps for the queries received from the DBQL.
    Result Rows The minimum number of rows returned for the queries retrieved from the DBQL.
    Select Users and Accounts Click to open the Select Users and Accounts dialog box and browse queries submitted by a set of users or accounts.

    To select a user, enter the user name in the Select User box, then click Add. You can also click List Users to list all users in the Select User list box. Select a name, then click Add.

    To select an account, enter an account in the Select Account box, then click Add. You can also click List Accounts to list all the accounts. Select an account, then click Add.

    To remove users or account names from the lists, select the user or account name in the list, then click Remove.

    Select Criteria
    Start Date Enter the date in the MM/DD/YYYY format to search for queries started on or after the specified date. If no start date is specified, all statements from the DBQL are loaded.
    End Date Enter the date in the MM/DD/YYYY format to search for queries ending on or before the specified date. If a start date is specified but no end date is specified, all statements from the DBQL beginning on the start date and ending on the current date are loaded.
    Start Time Enter the time in the HH:MM:SS format to search for queries on or after the specified start time. If no start time is specified, the default start time of 00:00:00 is used.
    End Time Enter the time in the HH:MM:SS format to search for queries on or before the specified end time. If no end time is specified, the default end time of 13:59:59 is used.
    Select QueryBand
    Name The name of a Query Band Name-Value pair.

    For more information about SET QUERY_BAND, see Teradata Vantage™ - SQL Data Definition Language Detailed Topics, B035-1184.

    Value The value of a Query Band Name-Value pair.
    List Names Click to list all the Query Band Names in the Name-Value list.
    Add Click to add the selected Query Band Name-Value pair to the Name-Value list.
    Rem Click to remove the selected Query Band Name-Value pair from the Name-Value list.
    Name-Value The combination of the Name and Value entries (Name-Value pair).
    Filter Click to filter out some of the Query Band Name-Value pairs.
  5. Click OK to close the Select Criteria dialog box and return to the DBQL Plans dialog box.
  6. Click Browse DBQL to load the XML queries from DBQL to add to the Query List.
  7. Select one or more queries by doing one of the following:
    • Select one query.
    • Hold Shift or Ctrl while selecting multiple queries.
    • Click Select All to select all of the queries.
  8. Click OK to add the XML queries to the Select Queries list.
  9. Under Export Options, select check boxes to define the exported information.