The data in Input file formed such a way that, for each 'A10' record there would be 1 or multiple 'A11' records with 'Pass' (P) or 'Fail' (F) indicator on subjects. Requirement is, I need to find out, how many 'A11' records are having 'P' status for specific 'SNO'.
As per the sample input data provided above, there are 4 'A10' records with one or more 'A11' records under it. I wanted to pull out data of all 'A11' records that are having 'P' status for only Students (SNO) being '1001' & '1002'. Just to minimize number of input records as an example purpose, i have provided only two SNO's, but actually I need to pull this data for around 20 students in the volume of 1500 students.
Joined: 22 Apr 2021 Posts: 7 Location: United States
Thank you for your help providing information on this.
Could you please clarify me on reason for using starting position as '49' in INCLUDE condition. Because our SNO starts in position '10' in 'A10' record. Just trying to understand for any specific purpose to have as '49'. When I run it, getting empty output file. Please advise.