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.