View previous topic :: View next topic
|
Author |
Message |
kunal jain
New User
Joined: 19 May 2011 Posts: 59 Location: India
|
|
|
|
HI,
Input file has below values
Code: |
COUNTRY Amounts
ASIA 25.00
EUROPE -200.00
INDIA -50.00
SRI LANKA 25.00 |
Two requirements here:
1. Need to overlay 'INDIA' & 'SRILANKA' with value as 'ASIA'.
So above file will look like as below:
Code: |
ASIA 25.00
EUROPE -200.00
ASIA -50.00
ASIA 25.00 |
2. ADD amounts country wise. so final output should be:
Code: |
ASIA 0.00
EUROPE -200.00 |
Please advise on DFSORT control card which can satisfy my above 2 requirements.
Also, please let me know if we can combine both steps in same DFSORT control card.
Thank you in advance
|
|
Back to top |
|
|
Pandora-Box
Global Moderator
Joined: 07 Sep 2006 Posts: 1592 Location: Andromeda Galaxy
|
|
|
|
Can you please use code tags?
And this post should belong to DFSORT forum. |
|
Back to top |
|
|
kunal jain
New User
Joined: 19 May 2011 Posts: 59 Location: India
|
|
|
|
Pandora-Box wrote: |
Can you please use code tags?
And this post should belong to DFSORT forum. |
Done as suggested. Apology for inappropriate forum, as am new to this.. |
|
Back to top |
|
|
Pandora-Box
Global Moderator
Joined: 07 Sep 2006 Posts: 1592 Location: Andromeda Galaxy
|
|
|
|
Try this
You might need to modify the code slightly for your needs
Code: |
//SORTIN DD *
ASIA 25.00
EUROPE -200.00
INDIA -50.00
SRI LANKA 25.00
//SORTOUT DD SYSOUT=*
//SYSIN DD *
INREC IFTHEN=(WHEN=(1,9,CH,EQ,C'INDIA'),OVERLAY=(1:C'ASIA ')),
IFTHEN=(WHEN=(1,9,CH,EQ,C'SRI LANKA'),OVERLAY=(1:C'ASIA '))
SORT FIELDS=(1,9,CH,A)
OUTFIL REMOVECC,NODETAIL,
SECTIONS=(1,9,
TRAILER3=(1,9,3X,
TOT=(13,8,SFF,EDIT=(SIIIIIIIT.TT),SIGNS=(,-))))
//* |
|
|
Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007 Posts: 2455 Location: Hampshire, UK
|
|
|
|
Quote: |
Apology for inappropriate forum, as am new to this.. |
For a first post this would almost be an acceptable excuse but 30+ posts over 2 years? No - it is just pain laziness in not taking due care. |
|
Back to top |
|
|
|