Creating the Query Processor Configuration File

An Query Processor configuration file is a sequential data (SEQDATA) file that you create using CANDE or some other text editor. There is no required naming convention for the file. The following syntax diagram illustrates the information you can enter in the file:

  ┌►────────────────────────────────────────┐
──┴─┬─/255*\─<release specification>──────┬─┴──────────────────────────┤
    ├─<user specification>────────────────┤
    ├─<program specification>─────────────┤
    ├─/1\─<default release specification>─┤
    └─<resource specification>────────────┘

The following table explains the elements of the syntax diagram.

Element

Definition

<release specification>

Defines the software to be used for a specified release. You must include at least one release specification in the Query Processor configuration file.

<user specification>

Defines the usercodes that have access to the specified release. The release specification that defines the software to which a user has access must precede the associated user specification in the Query Processor configuration file. The user specification also enables you to restrict the number of database operations executed under the specified usercode.

<program specification>

Enables you to restrict the number of database operations performed in one SQL query executed by the specified programs.

<default release specification>

Defines the software to be used by usercodes not specified in the user specification. You can include only one default release specification in the Query Processor configuration file.

<resource specification>

Defines a logical identifier that maps a Query Processor data source identifier to one or more physical databases.