Joined: 18 Mar 2007 Posts: 44 Location: New Jersey,USA
I have a requirement , where I need to insert a ACC.NO of customer on all his Address lines.
I/P records: Lrecl=080.
Cust.Name occurs in first 20bytes. then Customer no- 15 bytes. After this record I have the address lines of Customer , which is varying(ie) the number of records for address for each customer is different.
address line1 (---extends till 60 bytes) (last 20 bytes are filler)
address line 2
In ouptut my last 20bytes of address lines should have corresponding Acc.No of that customer.
O/P: LRECL same as I/P
address line1 (999999999999990)
address line 2 (999999999999990)
address line1 (999999999999991)
address line2 (999999999999991)
address line3 (999999999999991)
address line1 (999999999999992)
address line2 (999999999999992)
As The address lines occurences are varying for every customer I could not use Sampling method.