SQL Optimizer for DB2 LUW 4.3.1 - Installation Guide

Modify Job Details

You can modify the Job description, change the file type for source code files, and eliminate duplicate SQL while scanning.

Modifying a Job deletes the current scanning information.

To modify the Job

1. Mark the Jobs to be modified.

2. In the Job Manager window,right-click and select Modify.

3. The Modify Job dialog box allows you to do the following:

   Item	Description
   Description	Add an comment about the Job. This description is only displayed in Modify Job window.
   Job Type	When the Job is a source code file, select either Text or binary files or COBOL programming source code.
   Eliminate duplicate SQL	Check Eliminate duplicate SQL to only extract the identical SQL statement once for each Job.

4. Click OK.

5. Since modifying the Job deletes the current scanning information, click to rescan the Job if desired.