Operand

Description

name

One‑ to eight‑character program name.

version

Version of the program. For information on valid versions to specify, see Using Version Clauses in CA Ideal Commands in the “Preliminary Concepts” chapter.

option

Access plan option. If you omit the ENVIRONMENT clause, a fill‑in showing the current options from the program object displays. The options are shown in the table below:

CBSIO nnnnnn

I/O limit interrupt value for SQL statements that creates a set.

nnnnnn a value from 0 to 524287.

CLOSE time

Specifies whether to close the plan after each database transaction or at the end of the run‑unit or CICS job.

TRAN close after each transaction.

RUN close after the end of the run-unit.

DATE date‑format

Display format for SQL date type items.

DB CA Datacom installed default; one of the following formats

ISO International Standards organization: yyyy‑mm‑dd

USA U.S. standard: mm/dd/yyyy

EUR European standard: dd.mm.yyyy

JIS Japanese Industrial Standard: yyyy‑mm‑dd

DECPOINT x

Character used as the decimal point when data displays. This has no effect on how data is stored.

P Period (.) is used as the decimal point and comma is used as the digit separator.

C Comma (,) is used as the decimal point and period is used as the digit separator.

ISOLATION‑LEVEL level

Degree to which a unit of recovery is isolated from the updating operations of other units of recovery. Use for updates, deletes, or inserts.

U No locks are acquired.

R Repeatable read.

CS Cursor stability.

OPTMODE optmode

How CA Datacom/DB Database (CA Datacom) optimizes the ordering of table joins.

PREP Order joins during bind processing.

MAN Order joins as specified in FROM clauses.

EXEC Order joins at execution time. For more information, see the CA Datacom/DB Database SQL User Guide.

PRI nn

Priority level of the SQL requests.

nn The lowest priority is 1, the highest priority is 15.

STRDELIM x

Character used to delimit string values in all SQL statements.

A Apostrophes (') delimit string values.

Q Quotation marks (“) delimit string values.

TIME time‑format

Display format for SQL time type items.

DB

CA Datacom installed default; one of the following formats:

ISO International Standards Organization: hh.mm.ss

USA U.S. standard: hh:mm AM or PM

EUR European standard: hh.mm.ss

JIS Japanese Industrial Standard: hh:mm:ss

WAIT nnn unit Exclusive control wait limit.

nnn 1 to 120 minutes or seconds.

unit SEC for seconds or MIN for minutes. For example, for a ten‑second wait, enter the command WAIT 10 SEC.

OPTMSGS time type

Type of optimization messages CA Datacom/DB produces during bind processing or execution.

time PREP to set the type of message produced during bind processing; or EXEC to set the type of message produced during execution.

type

NON None (default)

DET Detail

SUM Summary

WORK space

Amount of workspace available at plan execution time (can be increased in response to specific SQL errors).

space 0 to 128 bytes, inclusive.