Activating Zero-Row SQL Commands

Use this procedure to activate SQL statements that do not affect any data.

To activate zero-row SQL commands

1. Click the Net Cost column head, and then scroll to the end of the list.

   This sorts commands by running time. Inactive commands have a running time of Not applicable and always appear at the end of the list.

2. Click in a row to display a command that returned zero rows.

3. Carefully evaluate whether you need this command for your upgrade.

4. To activate the command, click in the check box in the Inactive column.

   The following occurs:

   • The check mark disappears from the check box, indicating the command is active.

   • The word Changed appears next to the check box to indicate the change was made in this session.

   • The time displayed in the Net Cost column remains Not applicable.

   • When you save and exit, Upgrade Tuner activates the command in the SQL file.

   • The next time you start Upgrade Tuner, Not applicable is replaced by the running time for the command, and the word Changed does not appear.

5. Write down the SQL file name and SQL tag number for the command.

6. The next time you run Upgrade Tuner, locate the command and write down its net cost.

   You can use a spreadsheet to keep track of net cost changes, if you prefer.