Posted: Fri Apr 29, 2005 1:47 pm Post subject: Diff b/w splittng flds and havng it as a single fld in sort.
HI, I am wondering if there is a difference between the following sort cards in terms of performance. I am using SYNCSORT.
SORT FIELDS=(1,18,CH,A)
and
SORT FIELDS=( 1,13,CH,A,14,5,PD,A)
As far as the ouput is concerned, both the outputs matched as I had expected. I am trying to find out the CPU time by running the jobs with these 2 different control cards on the same CPU. But the jobs are not running in the same CPU nor do I know how to force to run th jobs in the same CPU.
Thanks,
Meg
Posted: Fri Apr 29, 2005 4:49 pm Post subject: Thanks Kolusu, but one more qn.
Thanks Kolusu.
But can you let me know why the performace is better when we split the fields and sort.
Also I have a question on the same lines.
We have a file out of which 10 records are having packed decimal values from 14th position to 18th. Also in the same file, there is a record which has a numeric field and another record which has alpha numeric values in the same postion. But if we sort the file using the SORT card SORT FIELDS=(1,13,CH,A,14,5,PD,A) the job does not end S0C7. How is sort able to handle numeric and spaces as PD?
Joined: 26 Nov 2002 Posts: 12376 Topics: 75 Location: San Jose
Posted: Fri Apr 29, 2005 5:30 pm Post subject:
Quote:
But can you let me know why the performace is better when we split the fields and sort.
Meg,
Here is an educated guess. Sort treates a character field as is represented by its 8-bit EBCDIC code where as each digit of the packed decimal number is converted into its 4-bit binary equivalent.
Quote:
We have a file out of which 10 records are having packed decimal values from 14th position to 18th. Also in the same file, there is a record which has a numeric field and another record which has alpha numeric values in the same postion. But if we sort the file using the SORT card SORT FIELDS=(1,13,CH,A,14,5,PD,A) the job does not end S0C7. How is sort able to handle numeric and spaces as PD?
Check this link which explains in detail about various data Formats. I hope frank wouldn't mind me linking a DFSORT manual link
Thanks Kolusu. From the link I was able to understand and test it out that since we were not doing any calculations using SUM or any other command and we were just sorting the input file, we did not receive any S0C7 errors.
Thanks,
Meg
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
