Process options, are displayed in the section below the Modify Filters options. The connection file and database to which you connect determine whether you can process the results to a database table. You need Create and Insert privileges on the database to process to a database table.
To set process options for a multiple-cycle, Interactive Reporting job:
Click Process Options (+) to display all process options.
Table 80. Process Options
Option
Description
Save job output with the job
For storing the job output in the folder containing the job
Save job output in another folder
For specifying an output folder
Process results to Interactive Reporting file
For processing queries to the Interactive Reporting file Results section
Process results to database table
For creating a database table to store the data set. (Items on the Request line become the column headings. You can append columns to the table and query it. You need Create and Insert privileges on the database to process to a database table.)
Query
For selecting the query to process to a database table.
Table Name
For entering the name of the table that you are creating or to which you are appending columns (See your database administrator if you want to use a new table.)
Create a table for each run, appending date to table name
For creating a table for each job run and appending the date to its name
Delete and recreate table for each job run
For deleting the old table and creates a table for each job run (Runs use the same table name.)
Create table on initial run, and then append data to existing table
For creating a table on the initial run and adding data to the table
Grant access to:
For entering additional usernames (separated by commas) (You need Grant privileges to use this field. If Grant Access to is not selected, the table is granted only to your user name.)