| View previous topic :: View next topic |
| Author |
Message |
mf_user
Intermediate
Joined: 01 Jun 2003
Posts: 372
Topics: 105
|
 Posted: Thu Jun 10, 2010 12:31 pm Post subject: |
 |
|
Kolusu, after looking into the old archives, I added OUTFIL FNAMES=OUT got the return code.
Thanks.
_________________
MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
== |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
| Posted: Thu Jun 10, 2010 12:36 pm Post subject: |
|
|
| mf_user wrote: | Kolusu, after looking into the old archives, I added OUTFIL FNAMES=OUT got the return code.
Thanks. |
Huh? why do you need to add FNAMES? I don't see a reason as to why you need to add it. Show me the sysout where DFSORT set a return code of zero for that job you have shown
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
Sqlcode
Intermediate
Joined: 15 Dec 2006
Posts: 157
Topics: 38
|
| Posted: Thu Jun 10, 2010 1:56 pm Post subject: |
|
|
mf_user,
| Quote: | | I've tried the below given sample SORT and it seems not working as expected.......I get MAXCC=0 |
Your sample sort is not matching your requirements. Please run the exact code Kolusu's has given in his topic at Wed Jun 09, 2010 12:04 pm and you will get what you want.
Thanks, |
|
| Back to top |
|
|
mf_user
Intermediate
Joined: 01 Jun 2003
Posts: 372
Topics: 105
|
| Posted: Thu Jun 10, 2010 3:02 pm Post subject: |
|
|
Kolusu - the genius has given alternative solution to this kind of problem on 4th March 2008 in other forum......hats off to you.
It has worked for me. Alas, I could not understand it either  
_________________
MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
== |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
| Posted: Thu Jun 10, 2010 3:58 pm Post subject: |
|
|
| mf_user wrote: | Kolusu - the genius has given alternative solution to this kind of problem on 4th March 2008 in other forum......hats off to you.
It has worked for me. Alas, I could not understand it either |
Mf_user,
So I assume you are NOT using DFSORT. From the next time when you say the proposed solution is not working as expected make sure you mention the product you are using.
Thanks
Kolusu |
|
| Back to top |
|
|
mf_user
Intermediate
Joined: 01 Jun 2003
Posts: 372
Topics: 105
|
| Posted: Thu Jun 10, 2010 10:30 pm Post subject: |
|
|
 I use DFSORT and Syncsort........but the problem is DFSORT is not latest and does not support the JNF1CNTL & JNF2CNTL......so, I did a google search and got this hit.........no other secrets. 
I would like to tell you that I got two to three other solutions for the same kind of question........given by either you or Frank......I was mentioning the instance to praise you and nothing else.......... 8)
Thanks.
_________________
MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
== |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
| Posted: Thu Jun 10, 2010 11:49 pm Post subject: |
|
|
| mf_user wrote: | I use DFSORT and Syncsort........but the problem is DFSORT is not latest and does not support the JNF1CNTL & JNF2CNTL......so, I did a google search and got this hit.........no other secrets.
I would like to tell you that I got two to three other solutions for the same kind of question........given by either you or Frank......I was mentioning the instance to praise you and nothing else.......... 8)
Thanks. |
Mf_user,
If you don't have DFSORT version that supports joinkeys , then specify that you indeed used Syncsort and got wrong results. Don't misguide that the proposed solution does not work with DFSORT.
Thanks
Kolusu |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
