Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Process between first and last records - SYNCSORT

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
chitanya

New User


Joined: 25 Jan 2008
Posts: 6
Location: Hyderabad

PostPosted: Tue Jul 20, 2010 6:01 pm    Post subject: Syncsort - how to remove first and last record
Reply with quote

Please let me know how to remove first and last record in sequential file using syncsort.

chaithu
Back to top
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Tue Jul 20, 2010 6:07 pm    Post subject:
Reply with quote

DO NOT just park your question on the end of another topic.
Start your own topic

Which version of SYNCSORT are you using.
DSORG, RECFM and LRECL of the input files.
Are the first and last records distinguishable from the rest of the records.
Any other processing involved, like sorting data or what.

Please learn to give all of the relevant information required to help you.
Back to top
View user's profile Send private message
chitanya

New User


Joined: 25 Jan 2008
Posts: 6
Location: Hyderabad

PostPosted: Tue Jul 20, 2010 6:20 pm    Post subject:
Reply with quote

Will not repeat the mistake again.
version of SYNCSORT for Z/OS is 1.3.2.1R

RECFM is fixed.
Rest all parameters will vary from one job to another job.
We can't distinguish first and last record.

My client need the first and last record to be skipped while loading file data into table.

Thanking you in advance,

Chaithu
Back to top
View user's profile Send private message
Ajay Baghel

Active User


Joined: 25 Apr 2007
Posts: 205
Location: Bangalore

PostPosted: Tue Jul 20, 2010 6:59 pm    Post subject:
Reply with quote

Hi Chitanya,

Generaly, the details records should be distinct from the header and trailer records with data in some byte position. See which program is writing to that. Based on that, you can easily take out only the details records using sort include cond statement.

Thanks
Ajay
Back to top
View user's profile Send private message
chitanya

New User


Joined: 25 Jan 2008
Posts: 6
Location: Hyderabad

PostPosted: Tue Jul 20, 2010 7:04 pm    Post subject:
Reply with quote

HI Ajay,

I asked my client to clarify regarding the same. I am yet to get reply.
Meanwhile i want to know is there a way to remove first and last record using SYNCSORT.

Regards,
Chaithu
Back to top
View user's profile Send private message
dick scherrer

Site Director


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

PostPosted: Tue Jul 20, 2010 11:37 pm    Post subject:
Reply with quote

Hello,

Suggest you use the code that works with ICETOOL. . .

If it does not work, post the informational or error messages generated by the run. Include the message id's.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Wed Jul 21, 2010 7:57 pm    Post subject:
Reply with quote

With your release of SyncSort, try this for a SyncTool Job -
Code:
//TOOLIN DD *                                         
SUBSET FROM(IN1) TO(OUT1) INPUT REMOVE HEADER TRAILER
/*                                                   
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SYNCSORT SEQNUM and FI fields. nartcr SYNCSORT 6 Sat Jan 21, 2017 4:02 am
No new posts Storing huge volume of data, compare ... Pradeep K M All Other Mainframe Topics 3 Mon Jan 16, 2017 5:08 pm
No new posts Syncsort Help to group fields sudhakarraju SYNCSORT 6 Thu Dec 29, 2016 1:38 am
No new posts Viewing executing process in NDM .. q... Debb.Brant IBM Tools 0 Wed Dec 14, 2016 10:55 pm
No new posts Removing Duplicates based on certain ... chandracdac DFSORT/ICETOOL 8 Fri Dec 09, 2016 4:40 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us