query regarding matching field value
Posted: Mon Feb 20, 2006 1:54 pm
hi all
i have a query.
actually i have an input file which has records beginning with a PIC XX field which can hold value 11,14,15,21.it has one more field pic x(15).
now i wanna move all fields from record starting with 11 to a output file.if the picx(15) digit of 11 matches with that of record whose pic xx =21, then i wanna move one field from 21 to corresponding field in output of 11.
let me explain it further.
if one record is 11 123 112123123123123 31 & another record is
21 333 112123123123123 23
record 11 has same pic x(15) as that of 21 so move 31 from 11 and 21 from 21 to same record of output file
thanks
i have a query.
actually i have an input file which has records beginning with a PIC XX field which can hold value 11,14,15,21.it has one more field pic x(15).
now i wanna move all fields from record starting with 11 to a output file.if the picx(15) digit of 11 matches with that of record whose pic xx =21, then i wanna move one field from 21 to corresponding field in output of 11.
let me explain it further.
if one record is 11 123 112123123123123 31 & another record is
21 333 112123123123123 23
record 11 has same pic x(15) as that of 21 so move 31 from 11 and 21 from 21 to same record of output file
thanks