Posts

Showing posts from July, 2015

Vsam tips

1) copy vsam to flat file 2) then process the flat file in subsequent steps 3) some times vsam is empty 4) when it is empty job abends //step3      exec   pgm=sort,parm='vsamemt=yes' //sysout    dd      sysout=* //sortin     dd      dsn=vsam.dsn,disp=shr //sortout   dd      dsn=flatfile.dsn,disp=shr //sysin      dd      *     sortfields = copy //* 2) how should be vsam file defined that it can be accessed both in cics and in batch     define shareoption(2,3) 3) vsam equivalent of tempdataset is to create vsam file with re-use option.      a dataset created with re-use can be treated as new dataset at any subsequent time. 4)vsam dataset - read only     //step1        exec pgm=idcams     //sysprint   dd    sysout=*    //sysin       ...

SQL user guide

Image
                                                                                                                                                                                     ...