chandra Beginner
Joined: 26 Sep 2003 Posts: 130 Topics: 36
|
Posted: Mon Dec 22, 2008 7:14 pm Post subject: Select records depending on condition |
|
|
Hi All,
I have following problem.
the field postions are as follows
Filler = Positon 1,length=5
Contract NBR = Positon 6,length=15
Filler = Positon 21,length=5
Address type = Positon 26,length=5 (RESID is resedent address, "MAIL " is mailing address type)
State code = Positon 31,length=2
Filler = Positon 33,length=5
If any contract number have a resident address type then mailing address needs to ignore and select the resident address type (without duplicates). If there is no resident address type then we need to select mailing address type record for that contract (without duplicates). The input file LRECL=37, RECFM=FB output file will be same.
Input file
[code:1:b50f39e696]
----+----1----+----2----+----3----+--
... _________________ Regards,
Chandra |
|