Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
When I run your job with DFSORT's ICETOOL, it does not ignore the SUM statement.
The message you received indicates you're using Syncsort's SYNCTOOL, not DFSORT's ICETOOL. DFSORT's ICETOOL is treating the operation as a SORT even though you have COPY in TOOLIN (the SORT statement is recognized and used). I suspect that Syncsort's SYNCTOOL is treating the operation as a COPY (the SORT statement is ignored).
Try changing COPY FROM... to SORT FROM... to see if that fixes the problem with Syncsort's SYNCTOOL.
Note that I'm a DFSORT developer. DFSORT and Syncsort are competitive products. I'm happy to answer questions on DFSORT and DFSORT's ICETOOL, but I generally don't answer questions on Syncsort. I was just feeling generous.
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
You may have coded PGM=ICETOOL, but you used Syncsort's SYNCTOOL, not DFSORT's ICETOOL. Syncsort chose to use ICETOOL as an alias for SYNCTOOL.
I know you used Syncsort, not DFSORT, because DFSORT does not issue the message you said you received - "SUM CONTROL STATEMENT IGNORED". If you look at that message, you'll see it is a WERcccs message (Syncsort), not an ICEcccs message (DFSORT). In the unlikely event it is an ICEcccs message, then what is ccc?
Quote:
I dont know why It ignored the SUM statement
I guessed why it ignored the SUM statement (because you did a COPY, not a SORT) and how to fix it (use SORT instead of COPY). Are you saying my guess is wrong and the fix didn't work?