Administration Guide

Creating a Result Destination

Use the following procedure to create a result destination:

1. In the QueryAdministrator main window, select the Result Set Administration tab.

2. Click New. An empty result destination window opens.

   
   
   

3. Enter a value in each of the fields listed in the table below.

4. Click OK after all values have been entered.
   

   Table 15. Fields to Define a Result Destination
   

   Field	Description
   Name	Provides the name for the result destination. QueryEnabler displays these names in the Result Destinations field when a user schedules a new query.
   Type	Indicates the type of destination: File indicates that the destination is a file. Pipe indicates that the destination is an executable program.
   Format	The only format supported is delimited ASCII.
   Description	For a file, the description provides the name of the file. For a pipe, the description provides the command line for the executable program. Descriptions for both types may contain any of the following substitution variables: $(USER) is the UNIX user ID. $(HOME) is the user's home directory. $(JOB) is the DB2 Query Patroller job number. $(PIPE) variable represents a named pipe. Instead of writing the data to the command's STDIN, DB2 Query Patroller writes the data to the named pipe.

[ DB2 List of Books | Search the DB2 Books ]