IBM Books

User's Guide


Setting Query Options

Depending on the query execution mode, you may need to set the execution date, the execution time, and the special submission options.

Setting the Execution Date

In the calendar section of the Schedule Query window, perform the following steps to set the execution date.

  1. Use the arrow push buttons above the calendar to select the month.

  2. Select a day of the month for the query to begin executing.

    The selected day displays darker than the other days in the month.

Setting the Execution Time

In the time section of the Schedule Query window, perform the following steps to set the execution time:

  1. Use the first set of up and down arrows to select the hour.
    Note:The a.m./p.m. designator cannot be set directly; it can only be set by setting the hour.

  2. Use the second set of up and down arrows to select the minute.

  3. Use the third set of up and down arrows to select the second.

Setting the Special Submission Options

In the special submission options section of the Schedule Query window, perform the following steps to set the special options.

  1. Select or deselect the Cost Analyze Query checkbox as needed.

  2. In the Priority field, select a priority from the drop-down list.

  3. In the Results Destinations field, select a result destination from the drop-down list.

  4. In the Query Name field, select a query name from the drop-down list. If needed, click Edit Names to add, delete, or edit a query name.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]