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 »
SORT JCL to Split data using OUTFILÂ The following sort card will sort split the input file into two files. First file will have records which have ‘AB’ at 266th position and second file will have records which have ‘AC’ at 266th position. INCLUDE=(266,2,CH,EQ,C’AB’) Â Â Â INCLUDE=(266,2,CH,EQ,C’AC’) Â Â Example JCL is provided below ;
SORT JCL to Split data using OUTFIL Read More »
Difference between Copy and Include I see we use COPY and Include for copying copybooks Can anyone list out the difference between these two commands? I have seen that for expanding cobol copybooks we are using COPY command but for expanding DB2 related copybooks like DCLGEN copybook or SQLCA copybook we use Include command. What
Difference between Copy and Include Read More »
SORT JCL to sort in Char format If you wish to SORT on positions with specific format in desired sequence. You can use the following The above card will sort the input file from 1st to 15th position with character format in ascending order Example JCL is provided below. ; ; ; ; //SORTIN Â
SORT JCL to sort in Char format Read More »
What does EXCP in SDSF mean Can some one explain the meaning of EXCP in SDSF? Searching on internet I found the following  “EXCP is EXecute Channel Program. This number refers to the num of I/O signal between mainframe and console.”  Is the above definition true or is this something else?
What does EXCP in SDSF mean Read More »
migrating from mainframe to micro focus MFE My company has decided to take up a project of migrating the entire code, database and files from mainframe to micro focus mainframe express at least for testing purpose. The intent of the project is to save MIPS cost spent in testing code on mainframe. I would like
migrating from mainframe to micro focus MFE Read More »
Topic / Topic starter Replies Last post Normal topic Can a table have more than one primary key by Anonymous » Fri, 11/18/2011 – 04:26 1 by Anonymous Fri, 01/11/2013 – 22:43 Normal topic fetch multiple rows without using CURSORS by Anonymous » Tue, 11/08/2011 – 10:06 0 by Anonymous Fri, 01/11/2013 – 22:43 Normal
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 »
The information technology (IT) sector has grown at a fast pace all around the globe, providing opportunities to people all across the planet. IT companies in India play a major role in the GDP of India, accounting to a total of more than 5 %. Indian IT services date back to 1967, when  the TATA
read a sequential file in reverse order in COBOL Is it possible to read a sequential file in reverse order in COBOL? One possible solution I could think of is to sort the file in reverse order and then read it, but I would want the discussion to be open for other solutions… Regards “;
read a sequential file in reverse order in COBOL Read More »
