15.00 - Load a query from DBQL - System Emulation Tool

Teradata System Emulation Tool User Guide

prodname
System Emulation Tool
vrm_release
15.00
category
User Guide
featnum
B035-2492-034K

Load a query from DBQL

1 Click DBQL Plans.

The DBQL Plans dialog box appears.

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.

    The Select Criteria dialog box appears.

    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 and then click Add. You can also click List Users to list all users in the Select User list box. Select a name and then click Add.

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

    To remove users or account names from the lists, select the user or account name in the list, and 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, refer to SQL Data Definition Language 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 in the Export by Query dialog.

    9 Under Export Options, select check boxes to define the exported information.

    See “Export Options”on page 79.