CA Easytrieve 2018 Options Table news and how to copy your existing 11.0 EZOPTBL to a new 11.6 EZOPTBL

book

Article ID: 108973

calendar_today

Updated On:

Products

CA PanAudit Plus CA Easytrieve Report Generator CA PAN/SQL

Issue/Introduction

There are new options in CA Easytrieve 11.6.

For instance, STRICTQU was added by PTFs SO00717 and SO00718.
If STRICTQU is set to W (default), the code will be compiled with a warning that IDXF is used to qualify the highlighted FILE-STATUS. This is compromise between the two following options.
If STRICTQU is set to N, the code will be compiled without any message.
If STRICTQU is set to E, the code won't be compiled and a "MORE QUALIFICATION REQUIRED" error is reported. 
 

Environment

Release:
Component: EZTPLS

Resolution

To move existing options, from 11.0 for instance, to a new Options Table, you just have to run two jobs as follows.
 
1. Run ETOPLOAD READFILE using your existing EZOTPBL data set and write SYSUT2 to a FB80 data set:
...
//LOADDEF EXEC PGM=ETOPLOAD                                 
//STEPLIB  DD  DISP=SHR,DSN=your.EZTP.R110.CAILIB  
//EZOPTBL  DD  DISP=SHR,DSN=your.EZTP.R110.EZOPTBL  
//SYSPRINT DD  SYSOUT=*                                    
//SYSUT2   DD DSN=your.EZTP.R110.EZOPTBL.SYSUT2,     
//            DISP=(,CATLG,DELETE),                        
//            DCB=(RECFM=FB,LRECL=80,BLKSIZE=3120),        
//            STORCLAS=your_stcclas,                                
//            SPACE=(CYL,(1,1))                            
//SYSIN    DD  *                                           
READFILE                                                   
/*                                                         
...
 
 
2. Create a new EZOPTBL using the SYSUT2 data set from step 1 above
 
...
//ALCOPT   EXEC PGM=IEFBR14                                            
//EZOPTBL  DD DSN=your.EZTP.R116.EZOPTBL.NEW,                   
//            DISP=(,CATLG,DELETE),                                     
//            DCB=(RECFM=F,LRECL=2048,BLKSIZE=2048),                   
//            STORCLAS=your_stcclas,                                       
//            SPACE=(2048,(4,1))                                       
//*------------------------------------------------------------------* 
//*  Create an Options Table                                           
//*------------------------------------------------------------------* 
//LOADDEF EXEC PGM=ETOPLOAD                                             
//STEPLIB  DD  DISP=SHR,DSN=your.EZTP.R116.CBAALOAD              
//EZOPTBL  DD  DISP=SHR,DSN=your.EZTP.R116.EZOPTBL.NEW          
//SYSPRINT DD  SYSOUT=*                                                
//OUTPUT   DD  SYSOUT=*                                                
//SYSUT2   DD  DUMMY                                                   
//SYSIN    DD  *                                                       
CREATEFILE                                                              
//         DD  DISP=SHR,DSN=your.EZTP.R110.EZOPTBL.SYSUT2       
//                                                                     
 
 
The new EZOPTBL contains the new values as well as the other values from the "old" EZOPTBL.
 

Additional Information

When comparing the old and the new table, you will see some differences as follows:
...

<Please see attached file for image>

User-added image
...

<Please see attached file for image>

User-added image
 

Attachments

1558698183782000108973_sktwi1f5rjvs16j8f.jpeg get_app
1558698181731000108973_sktwi1f5rjvs16j8e.jpeg get_app