How to resolve an EZTC0565E error and how to add an option to CA Easytrieve/Online

Document ID : KB000109766
Last Modified Date : 06/08/2018
Show Technical Document Details
Introduction:
When using CA Easytrieve/Online, there could be at least two reasons if you see
EZTC0565E >>> $ option not available 
with the Dollar sign below SQL, for example.
Instructions:
One reason could be that SQL-OPT was set to NO when CA Easytrieve/Online was installed.
See CAIIJMP member in the SAMPJCL library.
 
Another reason could be that an option was not added to your EZTSYS file.
Options will be added via BLDCOPY steps in the INSTJCL member on the INSTALL.JCL library.
Here is an example, how to add the SQL option to the CICS Batch part of CA Easytrieve/Online:
...
//OPTSQLB EXEC PGM=BLDCOPY,                                        
//             PARM='EZSQL TEXT S EZTSYS EZTOBJ = TXT (SEQ PIEVSAM'
//STEPLIB  DD  DISP=SHR,DSN=your.CA.EZT-ESP.V1R2.BATCH.LOADLIB
//EZTSYS   DD  DISP=SHR,DSN=your.CA.EZOL14.CICSB.EZTSYS
//PIESITE  DD  DISP=SHR,DSN=your.CA.EZT-ESP.V1R2.PIESYS
//SYSPRINT DD  SYSOUT=*,DCB=(LRECL=121,BLKSIZE=125,RECFM=VBA)      
//OUTPUT   DD  SYSOUT=*                                            
//SYSIN    DD  DISP=SHR,DSN=your.CA.EZOL14.CICS.INDOBJ(EZSQLB)
/*                                                                 
...
The same process is valid for other options too.
 
Please make a backup of your EZTSYS library before running such a BLDCOPY.
Additional Information:
As you know, there are 4 different parts of CA Easytrieve/Online:
TSO Online
TSO Batch
CICS Online
CICS Batch.