Previous Topic: Options You Can SpecifyNext Topic: Description of Options


Valid Options per Language

COBOL

PL/I

C

Assembler

APOST=

 

 

 

AUTHID=

AUTHID=

AUTHID=

AUTHID=

CBSIO=

CBSIO=

CBSIO=

CBSIO=

CHECKPLAN=

CHECKPLAN=

CHECKPLAN=

CHECKPLAN=

CHECKWHEN=

CHECKWHEN=

CHECKWHEN=

CHECKWHEN=

CHECKWHO=

CHECKWHO=

CHECKWHO=

CHECKWHO=

COBMODE=

 

 

 

DATE=

DATE=

DATE=

DATE=

DECPOINT=

DECPOINT=
DECPT=

DECPOINT=
DECPT=

 

GENSECTN=

 

 

 

 

GENSTOR=

 

GENSTOR=

 

GENINIT=

 

GENINIT=

 

 

 

INLINE=

ISOLEVEL=

ISOLEVEL=

ISOLEVEL=

ISOLEVEL=

ITYP=

ITYP=

ITYP=

ITYP=

 

LANGUAGE=
LANG=

LANGUAGE=
LANG=

LANGUAGE=
LANG=

 

MARGINS=

 

MARGINS=

MSG=

 

 

 

 

MSGEXEC=

MSGEXEC=

MSGEXEC=

 

MSGPREC=

MSGPREC=

MSGPREC=

OPT=

OPT=

OPT=

OPT=

PAGESZE=

PAGESZE=

PAGESZE=

PAGESZE=

PGMNAME=

 

 

 

PLANAME=

PLANAME=
PLANNAME=

PLANAME=
PLANNAME=

PLANAME=
PLANNAME=

PLNCLOSE=

PLNCLOSE=

PLNCLOSE=

PLNCLOSE=

PRTREXIT=

PRTREXIT=

PRTREXIT=

PRTREXIT=

PRTY=

PRTY=

PRTY=

PRTY=

QUOTE=

 

 

 

 

 

 

REFNTRY=

SAVEPLANSEC=

SAVEPLANSEC=

SAVEPLANSEC=

SAVEPLANSEC=

 

SMBR=

SMBR=

SMBR=

SQLMODE=

SQLMODE=

SQLMODE=

SQLMODE=

STRDELIM=

STRDELIM=
STRDLM=
STRINGDELIM=

STRDELIM=
STRDLM=
STRINGDELIM=

 

TIME=

TIME=

TIME=

TIME=

TIMEMIN=

TIMEMIN=

TIMEMIN=

TIMEMIN=

TIMESEC=

TIMESEC=

TIMESEC=

TIMESEC=

 

UCRPT=

 

UCRPT=

USRNTRY=

 

 

USRNTRY=

VIEWSEC=

VIEWSEC=

VIEWSEC=

VIEWSEC=

WORKSPACE=

WORKSPACE=

WORKSPACE=

WORKSPACE=

Regarding the CHECKPLAN=, CHECKWHEN=, and CHECKWHO= options that are used in plan security, following is a chart showing which combinations of those options are valid. Reference this chart when studying their descriptions in Description of Options.

Plan Options

Values

CHECKWHO (B=BINDER, A=ACCESSOR)

B

B

B

B

A

A

A

A

CHECKWHEN (B=BIND, E=EXECUTE)

B

B

E

E

B

B

E

E

CHECKPLAN (N=NO, Y=YES)

N

Y

N

Y

N

Y

N

Y

ALLOWABLE COMBINATION? (Y=YES, 1/2/3 see below)

1

Y

1

2

3

3

Y

Y

Reason Codes

  1. Not allowed because with plan-level security off, anyone could run this plan, and the executor's table-level privileges would not be checked.
  2. Not currently supported.
  3. Not allowed because SQL does not know at bind-time whom the executors are.