|
|
| Author |
Message |
naveensnayak
New User
Joined: 27 Nov 2006
Posts: 7
Location: Hyderabad
|
|
|
|
Hi,
Following is the Sort Card Used.
| Code: |
INCLUDE COND=(1,12,CH,EQ,C'KCLI601.I701')
SORT FIELDS=(1,12,CH,A,
13,2,FI,A,
19,3,CH,A,
22,5,CH,A,
27,3,CH,A,
15,1,CH,A,
30,22,CH,A,
52,22,CH,A,
74,2,FI,A,
16,1,CH,A,
78,1,CH,A,
79,60,CH,A,
159,40,CH,A,
139,20,CH,A)
SUM FIELDS=(76,2,FI)
|
When the Overflow occured at 76th and 77th positions as mentioned in SUM FIELDS , a Return COde of 0 is being Returned.
Is this true??
FYI NOEQUALS option is active.
But few days back a return code of 4 was returned when SUM overflow occured.
Today when same sort card and same input file are used a return code = 0 is returned.
Can you please explain when a RC = 4 or RC =0 is returned.
Thank You |
|
| Back to top |
|
 |
References
|
|
 |
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 3544
Location: Brussels once more ...
|
|
|
|
| Does it say in the output that a sum overflow ocurred ? |
|
| Back to top |
|
|
naveensnayak
New User
Joined: 27 Nov 2006
Posts: 7
Location: Hyderabad
|
|
|
|
Hi Expat,
Yes it says that SUM OVERFLOW OCCURED, in this case SORT is not deleting any of the records. Infact it is putting all records into the Output file.
The other case is that when there is SUM overflow(no message in SYSOUT but hav checked by manually calculating the sum), it is simply summarising the duplicate records and putting the sum in one record and deleting the other records.
In either of above cases we are getting RC = 0 |
|
| Back to top |
|
|
Frank Yaeger
DFSORT Moderator
Joined: 15 Feb 2005
Posts: 4613
Location: San Jose, CA
|
|
|
|
| Quote: |
| Can you please explain when a RC = 4 or RC =0 is returned. |
DFSORT's OVFLO=RC0/RC4/RC16 option determines whether it will pass back RC=0/4/16 when sum overflow occurs. If you got RC=4 for a SUM overflow, then OVFLO=RC4 was in effect. If you got RC=0 for a SUM overflow, then OVFLO=RC0 was in effect. The OVFLO option can be specified as an installation option by the site (the shipped default is OVFLO=RC0) or as a run-time option for a particular application. |
|
| Back to top |
|
|
|
|
|
