I am sorting on field 1 and 2 and the sum feild is on 3rd feild
Feild-3 is of 16 digits prededing with A + or - sign, so total length is 17 bytes.
So I could not use ZD ,FS,CFS formats as it is more that 17 bytes.
I even tried with FL but could not SUM it.
Can you please help me out in writing a sort step for the above.
Thanks a lot for your reply.
I just had a look at the link.
it talks about the "-" at the end but here we have the sign in front.
So ZD format does not work for the our requirement.
it is giving S0C7 error
Our shop does not have a DFsort.
So we need to work with normal sort to arrive to the above results.
Joined: 26 Nov 2002 Posts: 12369 Topics: 75 Location: San Jose
Posted: Thu Apr 06, 2006 4:48 am Post subject:
manojvoona,
Quote:
I just had a look at the link.
it talks about the "-" at the end but here we have the sign in front.
So ZD format does not work for the our requirement.
Read the entire link and see where I posted a solution using change command. I guess you can atleast change the solution to look for the sign at the beginning instead at the end.
Quote:
Our shop does not have a DFsort.
So we need to work with normal sort to arrive to the above results
There is nothing like normal sort. Your shop will have DFSORT or SYNCSORT or CA-SORT or some other sort product. Most shops have either DFSORT or SYNCSORT.
date in the file
+0000000000100000
+0000000000100000
After INREC ( using your change step)
{000000000100000
{000000000100000
After Sum feild
000000002000000
finally I could not change rechange 0 to +0 as the { is missing
Apart of this, if i need to sum 3 to 4 feilds the sort step becomes too combesome as we need to repeat change for each feild.
Joined: 26 Nov 2002 Posts: 12369 Topics: 75 Location: San Jose
Posted: Thu Apr 06, 2006 7:08 am Post subject:
Quote:
finally I could not change rechange 0 to +0 as the { is missing
Apart of this, if i need to sum 3 to 4 feilds the sort step becomes too combesome as we need to repeat change for each feild.
Is there some other simpler way to do that
manojvoona,
The best approach to learn something is follow directions. Read my prior post carefully and answer the questions.
I asked specific questions and once you answer them I can suggest a solution. However you seem to ignore them. By doing so you are wasting my time as well as your time. Remember that I also work for someone else for my livelyhood.
Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
Posted: Thu Apr 06, 2006 10:47 am Post subject:
Quote:
So ZD format does not work for the our requirement.
For the record, DFSORT's FS and SFF formats would work for reformatting values like:
+0000000000100000
The maximum length for FS is 32 bytes (with up to 31 digits) and the maximum length for SFF is 44 bytes (with up to 31 digits). _________________ Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
Posted: Thu Apr 06, 2006 1:01 pm Post subject:
Manoj,
I was just pointing out that DFSORT could handle these large numbers with FS and UFF, in response to your statement
Quote:
So I could not use ZD ,FS,CFS formats as it is more that 17 bytes.
Although you said in your first post that you were using DFSORT, you corrected yourself in your second post to say that you were using Syncsort. DFSORT can handle the large SFF numbers. Syncsort doesn't support SFF or large numbers - that's what the WER (Syncsort) messages are telling you. _________________ Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
