|
View previous topic :: View next topic
|
| Author |
Message |
krunal7757
New User
Joined: 01 Sep 2021
Posts: 6
Location: INdia
|
|
|
|
Hi Team -
i have input file with multiple header and multiple trailer based on acount number in file.
i am adding additional records to above file before sending to client. When i add records i need to update the totals for matching account number.
trailer total will have count and total amount
i triled below
| Code: |
SORT FIELDS=(1,12,CH,A)
OUTFIL FNAMES=SORTOUT,
IFTHEN=(WHEN=(13,1,CH,EQ,C'T'),
BUILD=(1:1,13,14:COUNT=(M11,LENGTH=10),
24:TOT=(43,12,ZD,TO=ZD,LENGTH=12),115X),
REMOVECC |
but i am getting below error
| Code: |
WER813I INSTALLATION OPTIONS IN MFX LOAD LIBRARY WILL BE USED
WER268A OUTFIL STATEMENT : SYNTAX ERROR
WER211B SYNCSMF CALLED BY SYNCSORT; RC=0000
WER449I SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE |
trying since last 4 hr.. can you helpin this
Coded for you |
|
| Back to top |
|
 |
sergeyken
Senior Member
Joined: 29 Apr 2008
Posts: 2141
Location: USA
|
|
|
|
Code tags!! - first of all
And code alignment! - second thing to do
Answer to the question - after that
 |
|
| Back to top |
|
|
sergeyken
Senior Member
Joined: 29 Apr 2008
Posts: 2141
Location: USA
|
|
|
|
Learn counting parenthesis!
| Code: |
IFTHEN=(WHEN=(…),
BUILD=(…)),
REMOVECC |
|
|
| Back to top |
|
|
krunal7757
New User
Joined: 01 Sep 2021
Posts: 6
Location: INdia
|
|
|
|
Thank you for the reply sir,
I did check the paranthesis post the question. But that is also not working for me
currently what i have coded is
SORT FIELDS=(1,12,CH,A)
OUTFIL FNAMES=SORTOUT,REMOVECC,
IFTHEN=(WHEN=(13,1,CH,EQ,C'T'),
BUILD=(1:1,13,14:COUNT=(M11,LENGTH=10),
24:TOT=(43,12,ZD,TO=ZD,LENGTH=12),115X)))
i tried overlay too but no success.
I am sorry my post is giving me warning but mistake done by me is unintentional and not to hurt any one
really need the support to solve this query |
|
| Back to top |
|
|
sergeyken
Senior Member
Joined: 29 Apr 2008
Posts: 2141
Location: USA
|
|
|
|
Code tags!!!
And code alignment!!!
You are just not able to count things up to ten. It’s a pity… 
It all has nothing to do with OVERLAY.
Your problem is - inability to count properly.
Try at least once in your life to place your code in a pretty manner.
You’ll like it, and your problems should be fixed by themselves, without appealing to the forum.
P.S.
After fixing the number of parenthesis you may find that parameters COUNT= and TOT= are not allowed where you put them… |
|
| Back to top |
|
|
Joerg.Findeisen
Senior Member
Joined: 15 Aug 2015
Posts: 1335
Location: Bamberg, Germany
|
|
|
|
This is neither DFSORT nor ICETOOL. Please learn to post in SYNCSORT part of the forum when you are asking questions about it.
Topic should be moved to the to SYNCSORT forum.  |
|
| Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3076
Location: NYC,USA
|
|
|
|
Welcome !
Couple of things in addition, always provide sample input and expected output . Second use the SEARCH to find related post and try to resolve by yourself.
E.g. ibmmainframes.com/about49607.html |
|
| Back to top |
|
|
|
|
