Remove particular records from Syncsort



Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL

Remove particular records from Syncsort

Postby meena » Wed Nov 23, 2011 11:23 am

how to remove particular 5th,9th,11th record from the input file using syncsort.. i'm using SYNCTOOL RELEASE 1.6.0 so my version is not supporting icetool's subset/datasort commands.. kindly suggest some way
meena
 
Posts: 11
Joined: Sat Oct 22, 2011 11:59 am
Has thanked: 0 time
Been thanked: 0 time

Re: Remove particular records from Syncsort

 

Re: syncsort

Postby dick scherrer » Wed Nov 23, 2011 12:19 pm

Hello,

Try appending an sequence number when readking the data and OMITing the sequence numbers you do not want in the outp

See if this helps:
syncsort-synctool/topic11.html#p5411
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: syncsort

Postby NicC » Wed Nov 23, 2011 12:20 pm

If it is a SYNCSORT solution you are wanting why not post in the Syncsort part of the forum? This is the JCL part - Job Control Language - something completely different.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2702
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 105 times

Re: syncsort

Postby Anuj Dhawan » Wed Nov 23, 2011 1:12 pm

meena wrote:how to remove particular 5th,9th,11th record from the input file using syncsort.. i'm using SYNCTOOL RELEASE 1.6.0 so my version is not supporting icetool's subset/datasort commands.. kindly suggest some way
This is doable, there are some working examples also in this forum; however, if you are looking for an exact answer, you need to a better job in explainng the requirements.

Do you have only 11 records in input file? Out of which you want to copy 5th,9th,11th records? What should be the next record in output - 15th? Is it a one time task - looks like no, as you want to do it using SyncSort. So what is the LRECL, RECFM of input an output?

Suggest you show some sample input and the expected output from that as well.
Anuj
Anuj Dhawan
 
Posts: 274
Joined: Mon Feb 25, 2008 3:53 am
Location: Mumbai, India
Has thanked: 6 times
Been thanked: 4 times

Re: syncsort

Postby meena » Wed Nov 23, 2011 2:26 pm

i'm having some lakhs of records in the input file(nacha format)... i need to delete depending upon the needs..sometimes i need to delete 50th record or 1009th record..so i tried to write a jcl with a utility to delete the mentioned record no..i came accross icetool-->subset functionality..but i'm in need of syncsort..
hi dick,
since so many records are there using seqno is a good way?
kindly give me the soln
meena
 
Posts: 11
Joined: Sat Oct 22, 2011 11:59 am
Has thanked: 0 time
Been thanked: 0 time

Re: syncsort

Postby NicC » Wed Nov 23, 2011 8:30 pm

What is 'nacha' format? I only know of FB and VB for record types and PS, PDS, PDSE, VSAM etc for dataset types.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2702
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 105 times

Re: syncsort

Postby Akatsukami » Wed Nov 23, 2011 8:38 pm

NicC wrote:What is 'nacha' format?

It's the Electronic Payments Association.
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Akatsukami
Global moderator
 
Posts: 1054
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times

Re: syncsort

Postby BillyBoyo » Wed Nov 23, 2011 8:42 pm

Can you tell us what you are trying to achieve by deleting such records?
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Re: syncsort

Postby dick scherrer » Thu Nov 24, 2011 1:35 am

Hello,

Can you tell us what you are trying to achieve by deleting such records?

They have been bad and are no longer permitted to participate. . . Or they will cause problems if processed and are being remove before the problem process.

Scary but it is better to remove a problem and have a successful run (say the payroll), document the action taken, and hopefully correct the code that caused/allowed the problem before the next run.

since so many records are there using seqno is a good way?
Why would it not be?
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: syncsort

Postby meena » Thu Nov 24, 2011 9:44 am

hi dick,

i tried as u said but its giving error...i did the same wit sort but in two steps....can you suggest the sysin part for synsort in one step...my file recleng is 94...
meena
 
Posts: 11
Joined: Sat Oct 22, 2011 11:59 am
Has thanked: 0 time
Been thanked: 0 time

Next

Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post