Hello Listeners,

I have a input sequential file as below

segno   empno    empstatus  restofdetails
101       10001       T               ABC
102       10001                        PRS
103       10001                        XYE
101       10002       T               ABC
102       10002                        PRS
103       10002                        XYE
101       10003       A               ABC
102       10003                        PRS
103       10003                        XYE


Here in the above file i need to pull all of the records having empstatus = 'T' 
using a sort
The issue is if the empstatus is "T'" i need to pull the related of the empno 
to the outfile also

sample o/p is below

segno   empno    empstatus  restofdetails
101       10001       T               ABC
102       10001                        PRS
103       10001                        XYE
101       10002       T               ABC
102       10002                        PRS
103       10002                        XYE

Could someone in the list pls let me know how to do the extracation?


Regards
Ron T

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN

Reply via email to