Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 8666
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 Process file after 7 days of hold charlessxavier All Other Mainframe Topics 0 Tue May 22, 2018 3:54 pm
No new posts MXG - Processing Compressed DB2 SMF r... vasanthz All Other Mainframe Topics 2 Thu May 10, 2018 12:47 am
No new posts Reformatting and adding additional fi... Badbeef SYNCSORT 6 Thu Apr 05, 2018 4:45 pm
No new posts Extract the records with a PD field's... sudhakar84 DFSORT/ICETOOL 11 Mon Apr 02, 2018 7:26 pm
No new posts Merge 2 records sancraig16 SYNCSORT 19 Tue Mar 27, 2018 8:17 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us