The program specification enables you to restrict the number of database operations performed in one SQL query executed by the specified programs. The main purpose of the program specification is to enable a limit value linked to a usercode to be overridden when a particular application program is executed. If an SQL query is executed and both the program and the usercode have explicit limits on the number of database operations in a query, then the larger limit applies.
The following diagrams illustrate the syntax of the program specification:
<program specification>
┌►────── , ──────┐ ── PROGRAM ─┴─<program name>─┴─<limit clause>──────────────────────────┤
<limit clause>
── LIMIT ─┬─────┬─┬─<limit value>─┬────────────────────────────────────┤
└─ = ─┘ └─ UNLIMITED ───┘The following table explains the elements of the syntax diagrams.
|
Element |
Definition |
|---|---|
|
<program name> |
Identifies the name of the file containing the code for the data management software. This program name has the same syntax as the <file title> variable within a release specification, except the usercode and family name must be explicitly stated. |
|
<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. |
