View previous topic :: View next topic
|
Author |
Message |
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
Quote: |
I have tried with EXEC PGM=ICETOOL, Got RC = 20 |
In case it helps, for DFSORT's ICETOOL, RC=20 is issued if you do not have the //TOOLMSG DD.
If that's not the problem, then i suggest you show your complete JCL for the SELECT job. I'm guessing you set it up wrong. |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
Hi,
siva102 wrote: |
I dont know exactly wt type of sort we are having. |
Check the SYSOUT of some SORT JOB, if the messages appear there are of type ICExxxx then your shop make use of DFSORT & if messages are of type WERxxxx it's SyncSort. Both of these are competitive products and on this portal they are discussed under different forums. Syncsort falls under JCL forum & DFSORT question are discussed in DFSORT & ICETOOL forum.
Quote: |
Actully i just did QW SORT AND there it shows like SYNCSORT. |
MVS/QuickRef product is like "tutorial" it would contain a general information, it's not the right place to get such information. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
If this is still not working, please post all of the jcl and sort control statements for this step as well as the all of the information created by the step (including the message ids) when the step was executed.
Use copy/paste and the "Code" tag to post this info. Do not post the messages from JJ or some other jcl-check tool. |
|
Back to top |
|
|
siva102
New User
Joined: 28 Nov 2007 Posts: 63 Location: Chennai
|
|
|
|
Hi all,
Thanks to Dick and Frank. The RC = 20 error has been resolved.
Now the JCL runned successfully but the output remains the same. Please chk the JC that i runned,
Code: |
//******* JOB ('TEST'),MSGCLASS=O,CLASS=T,NOTIFY=&SYSUID
//*STEP1 EXEC PGM=SORT
//STEP1 EXEC PGM=ICETOOL
//SORTIN DD DSN=Input File,
// DISP=SHR
//SYSOUT DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//SORTOUT DD DSN=Out1
// DISP=(OLD,CATLG,DELETE),
// UNIT=SYSDA,
// SPACE=(CYL,(15,15),RLSE),
// DCB=*.SORTIN
//SORTXSUM DD DSN=out2,
// DISP=(OLD,CATLG,DELETE),
// UNIT=SYSDA,
// SPACE=(CYL,(15,15),RLSE),
// DCB=*.SORTIN
//TOOLMSG DD SYSOUT=*
//TOOLIN DD *
SELECT FROM(SORTIN) TO(SORTOUT) ON(1,99,CH) ON(122,278,CH) -
NODUPS DISCARD(SORTXSUM)
/*
If my file is having 3 duplicate records then one record is going to OUT1 and the other two to OUT2.
But i need aal the 3 records need to goto OUT2.
Please help me regarding this.
|
|
|
Back to top |
|
|
gcicchet
Senior Member
Joined: 28 Jul 2006 Posts: 1702 Location: Australia
|
|
|
|
Hi,
instead of NODUPS, try ALLDUPS except all dups will be written to SORTOUT
Gerry |
|
Back to top |
|
|
siva102
New User
Joined: 28 Nov 2007 Posts: 63 Location: Chennai
|
|
|
|
Hi Gerry,
I m still not getting the required output.
The output that i got right now is same as the previous one only. |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
Siva,
Can you post the contents of input data you used at positions- (1,99,CH) and (122,278,CH)
Thanks,
Arun |
|
Back to top |
|
|
siva102
New User
Joined: 28 Nov 2007 Posts: 63 Location: Chennai
|
|
|
|
Hi all,
At last the work got completed.
Thanks to everyone. I really learned a lot of things here.
The SORT CARD that i used was,
//TOOLIN DD *
SELECT FROM(SORTIN) TO(SORTOUT) ON(1,99,CH) ON(122,278,CH) -
ALLDUPS DISCARD(SORTXSUM)
Thank u all..... With out u guys help i cannot even move a little more step.
Once again thaks for u guys concerns abt the task. |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
Siva,
Thanks for letting know that you reached your solution . Still I m not clear on the below part.
Quote: |
If my file is having 3 duplicate records then one record is going to OUT1 and the other two to OUT2.
But i need aal the 3 records need to goto OUT2. |
Using ALLDUPS will route all the unique-keyed records to your DISCARDdd which is nothing but your "OUT2". Is n't it contradicting your above statement.
Please let me know if I m missing something here.
Thanks,
Arun |
|
Back to top |
|
|
siva102
New User
Joined: 28 Nov 2007 Posts: 63 Location: Chennai
|
|
|
|
Hi arun,
What you pointed is correct only but the ultimate result i want is to remove the duplicates from the input file.
So here by using ALLDUPS i got all the duplicates to OUT1.
Where ever it goes may be but i was able to separate the duplicates, right ???
Thank you very much for your concern. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Good to hear it is working - thank you for the follow-up
d |
|
Back to top |
|
|
|