Can we read empty VSAM file using COBOL We know that we face abend when we try to read an empty vsam file in a cobol program, some file status 35 comes. We generally would place a low value record (null record as we refer) to overcome this problem. But I fail to understand what […]
Can we read empty VSAM file using COBOL Read More »
If the VSAM is empty then copy job abends There may be a situation where you have to copy a VSAM file to a flat file and if the VSAM file for some reason is empty then the sort copy job abends with abend code of U0016. Please refer the following JCL //SORTIN DD DSN=VSAM.DSN,DISP=SHR
If the VSAM is empty then copy job abends Read More »
File Manager to get record count of VSAM You can use the following steps to get the record count in VSAM file Step2: File (To invoke file manager) Step3:  On the  “PRIMARY OPTION MENU” screen chose option  3 (Utilities) Step4:  From the “UTILITY FUNCTIONS” screen choose option 4 (Dslist). Step5: On the “CATALOG SERVICES” screen, Provide
File Manager to get record count of VSAM Read More »
Reading last record in VSAM file Is it possible to read the last record of a VSAM file directly? I have faced this question in an interview. The vsam file can be accessed sequentially as well as randomly using a key. But how to make sure that we read the last record of the VSAM
Reading last record in VSAM file Read More »
Load VSAM data to DB2 TABLE In my current project, we are trying to convert all the VSAM files to DB2 TABLES. We have created the DB2 tables for each VSAM file. Now we need to load the data from VSAM files to DB2 tables. One approach that I have in my mind is to
Load VSAM data to DB2 TABLE Read More »
LRECL and RECFM for flat file created by VSAM unload I have to Unload a VSAM file to a flat file, I think I can do this using REPRO command of IDCAMS utility, my question is what should be the record length and record format that I should specify for the flat file to which
LRECL and RECFM for flat file created by VSAM unload Read More »
Alternat Index file in VSAM upon loading VSAM file I have a VSAM file which has alternate index defined. Now I am replacing all the data in this file with new data. I am going to use IDCAMS repro for doing this, it should load the data in the VSAM file, but for the alternate
Alternat Index file in VSAM upon loading VSAM file Read More »
What is a VSAM? In 1970 when IBM launched the virtual storage operating systems OS/VS1 and OS/VS2, the access methods (ISAM and BDAM) used in the older versions of the operating systems when used with the newer OS started giving performance issues. To overcome performance issues and device dependence, new access methods were introduced replacing
How to read a VSAM file with Partial Key I have to read a VSAM file in my COBOL program but I do not have the full key at the time of accessing the file, is it possible to read the VSAM file using partial key. It would be great, if someone can provide an
How to read a VSAM file with Partial Key Read More »
How to convert a VSAM file to flat file? I have a VSAM file and I have to transfer (FTP) the file to a PC, now I do not know if I can transfer the VSAM file directly, one friend told me that I have to convert it to flat file. How do we convert it to
How to convert a VSAM file to flat file? Read More »
