The following options are valid only when submitted with a program with embedded SQL. You cannot change them on the REBIND PLAN panel. For more information on options submitted with a program with embedded SQL, see Options You Can Specify.
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= |
DECPOINT= |
|
|
GENSECTN= |
|
|
|
|
|
GENSTOR= |
|
GENSTOR= |
|
|
GENINIT= |
|
GENINIT= |
|
|
|
|
INLINE= |
|
ISOLEVEL= |
ISOLEVEL= |
ISOLEVEL= |
ISOLEVEL= |
|
ITYP= |
ITYP= |
ITYP= |
ITYP= |
|
|
LANGUAGE= |
LANGUAGE= |
LANGUAGE= |
|
|
MARGINS= |
|
MARGINS= |
|
MSG= |
|
|
|
|
|
MSGEXEC= |
MSGEXEC= |
MSGEXEC= |
|
|
MSGPREC= |
MSGPREC= |
MSGPREC= |
|
OPT= |
OPT= |
OPT= |
OPT= |
|
PAGESZE= |
PAGESZE= |
PAGESZE= |
PAGESZE= |
|
PLANAME= |
PLANAME= |
PLANAME= |
PLANAME= |
|
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= |
STRDELIM= |
|
|
TIME= |
TIME= |
TIME= |
TIME= |
|
TIMEMIN= |
TIMEMIN= |
TIMEMIN= |
TIMEMIN= |
|
TIMESEC= |
TIMESEC= |
TIMESEC= |
TIMESEC= |
|
|
UCRPT= |
|
UCRPT= |
|
USRNTRY= |
|
|
USRNTRY= |
|
VIEWSEC= |
VIEWSEC= |
VIEWSEC= |
VIEWSEC= |
|
WORKSPACE= |
WORKSPACE= |
WORKSPACE= |
WORKSPACE= |
The following options are valid only when submitted in a source member with a *$DBSQLOPT statement or with a program with embedded SQL. You cannot change them on the REBIND PLAN panel:
For more information about DECPOINT= and STRDELIM= see Options You Can Specify.
You can specify alternate values for the following plan options in the Interactive SQL Service Facility.
|
Plan Option on |
Plan Option in |
Preprocessor |
|---|---|---|
|
CBSIO |
CBSIO= |
CBSIO= |
|
MSG-EXEC |
PLNMSGPE= |
MSG= (COBOL) |
|
PLNCLOSE |
PLNCLOSE= |
PLNCLOSE= |
|
PLNDATE |
PLNDATE= |
DATE= |
|
PLNISOLA |
PLNISOLA= |
ISOLEVEL= |
|
PLNJOVRD |
PLNJOVRD= |
OPT= |
|
PLNTIME |
PLNTIME= |
TIME= |
|
PLNWKSP |
PLNWKSP= |
WORKSPACE= |
|
PRIORITY |
PRTY= |
PRTY= |
|
SQLMODE |
SQLMODE= |
SQLMODE= |
|
TIMEMIN |
TIMEMIN= |
TIMEMIN= |
|
TIMESEC |
TIMESEC= |
TIMESEC= |
* In the Preprocessor column, except where noted the listed options are for COBOL, PL/I, C, and Assembler.
|
Copyright © 2014 CA.
All rights reserved.
|
|