I have a requirement like the following:
This is the first record in my input file:
UPDATE PL1_SUP* WHERE POLICY_ID = 101737893 AND STATUS CODE = M570 --- first line
The above has to be splitted into like the following following:
UPDATE PL1_SUP* --- i.e . after splitting this should come in the first line
WHERE POLICY_ID = 101737893 ---- i.e. t his should come in the first line
AND STATUS CODE = M570 ---------i.e. this should come in the first line
I have around 30,000 records in my input file and each record has to be splitted as above.
Could any help me out.Is this possible any sort utility?
Please help me.
Many thanks,
Naveen S