muthuvel Active User Joined: 29 Nov 2005 Posts: 217 Location: Chennai
I Have a flat file.
I Have to add a packed decimal value to a particlular field present in the flat file.
Input file(LRECL:80 bytes)
I Have to add 200 to all the Salary values present in the Input file.
The Salary field and the Value to be added(200) both are packed decimals.
Is it possible to achieve this in a single stel using a ICETOOL.
Expecting eagerly for your help..
Frank Yaeger DFSORT Moderator Joined: 15 Feb 2005 Posts: 7130 Location: San Jose, CA
You don't really need ICETOOL to do this, as you can do it with a simple DFSORT COPY step, but you can use a DFSORT/ICETOOL COPY instead if you want to. Let's assume your PD field is in positions 11-15. Then you could use this DFSORT INREC statement to add +200 to that field:
Just change the control statement appropriately for the actual starting position and length of the PD field.
All times are GMT + 6 Hours