IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

SYNCSORT Splitting the file


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
siva102

New User


Joined: 28 Nov 2007
Posts: 63
Location: Chennai

PostPosted: Mon Sep 22, 2008 12:28 pm
Reply with quote

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
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2481
Location: @my desk

PostPosted: Mon Sep 22, 2008 1:13 pm
Reply with quote

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
View user's profile Send private message
siva102

New User


Joined: 28 Nov 2007
Posts: 63
Location: Chennai

PostPosted: Mon Sep 22, 2008 1:23 pm
Reply with quote

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
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2481
Location: @my desk

PostPosted: Mon Sep 22, 2008 1:53 pm
Reply with quote

Siva,

Thanks for letting know that you reached your solution icon_biggrin.gif . Still I m not clear on the below part. icon_rolleyes.gif
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
View user's profile Send private message
siva102

New User


Joined: 28 Nov 2007
Posts: 63
Location: Chennai

PostPosted: Mon Sep 22, 2008 2:53 pm
Reply with quote

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
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Mon Sep 22, 2008 7:58 pm
Reply with quote

Good to hear it is working - thank you for the follow-up icon_smile.gif

d
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM Goto page Previous  1, 2

 


Similar Topics
Topic Forum Replies
No new posts Compare 2 files and retrive records f... DFSORT/ICETOOL 3
No new posts FTP VB File from Mainframe retaining ... JCL & VSAM 8
No new posts Extract the file name from another fi... DFSORT/ICETOOL 6
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
Search our Forums:

Back to Top