User Specification

The user specification defines the usercodes that have access to the specified software release. If you do not include a user specification in the Query Processor configuration file, all users have access to the software designated in the default release specification. You can include one or more user specifications in the Query Processor configuration file.

The following diagrams illustrate the syntax for the user specification:

<user specification>

── USER ───────────────────────────────────────────────────────────────────────►
  ┌►────────────────────────────────────────────────────────────────────────┐
  │ ┌►──────── , ───────┐                                                   │
►─┴─┴─<user identifier>─┴─┬──────────────────┬─┬─────┬─<release identifier>─┴──┤  
                          └─ <limit clause> ─┘ └─ = ─┘

<user identifier>

──┬─<usercode>───────────┬─────────────────────────────────────────────┤
  └─ ( ──<usercode>── ) ─┘

<limit clause>

── LIMIT ─┬─────┬─┬─<limit value>─┬────────────────────────────────────┤
          └─ = ─┘ └─ UNLIMITED ───┘

The following table explains the elements of the syntax diagrams.

Element

Definition

<user identifier>

Specifies a user who has access to the software described in the release specification. The user identifier can consist of a single usercode or a list of multiple usercodes separated by commas (,).

If a usercode is the same as one of the following keywords, the usercode must be encased in parentheses; otherwise, the use of parentheses is optional. The keywords are MCPSQL, RELEASE, USER, RESOURCE, and DEFAULT.

You can specify a usercode for multiple releases; however, only the last specification in the file is used. If a usercode does occur multiple times, a warning message appears.

<release identifier>

Names a release identifier used in a release specification. The designated release identifier must appear in a release specification before it can be used in a user specification.

<limit clause>

Enables the system administrator to impose an upper limit on the number of database operations performed by a single SQL query. Refer to Using the Limit Clause later in this section for limit clause information.

<limit value>

Identifies the maximum number of database operations allowed in one SQL query. The limit value must be an integer between 1 and 1000000.

UNLIMITED

Indicates that no limit is applied to the specified usercodes. UNLIMITED is the default if no limit clause is specified.

Prev  Up  Next
Release Specification  Home  Program Specification