Greetings
I recently started a research to find out better ways to extract data from ADABAS mainframe into servers. We have limited resources and so far are thinking to utilize the ADACMP which supports the extended MU and PE limits and spanned records as input.
Our group does not have access to ADACMP utility, only DBA have. The main problem we are coming across is to identify the infile ISN format to include in the JCL. We must come out with the right syntax to “automate” the following format , in this case for file 264 (have must find out the correct format for hundreds of files)
ADACMP DECOMPRESS INFILE=264,ISN
ADACMP FORMAT=‘AH,AJ,AK,AL,AM,AN,AO,AP,AQ,AF,AS,AT,AU,’ -
ADACMP FORMAT=‘AV,AW,AX,AY,AZ,BA,AE,AD,BB,BC,BD,AC,BL,’ -
ADACMP FORMAT=‘BM,BO,BP,BQ,BR,BT,BV,BW,BX,BY,AA,AB,CG,’ -
ADACMP FORMAT=‘CH,CI,CJ,CK,CL,CM,’ -
ADACMP FORMAT=‘BE1-5,BH1-5,BZ1-3,CC1-5,CQ1-3,CR1-5,CS1-5’
Aside from being time consuming, our team is also afraid of the human factor margin of error, where in order to automate this on a PC and upload to the mainframe so the DBAs can run the decompress JCL
Is there a better way that we might be overlooking? Please share your knowledge as we would appreciate any valuable advise