Process between first and last records - SYNCSORT

chitanya · New User Joined: 25 Jan 2008 Posts: 6 Location: Hyderabad

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

chaithu

expat · Posted: Tue Jul 20, 2010 6:07 pm

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.

chitanya · New User Joined: 25 Jan 2008 Posts: 6 Location: Hyderabad

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

Ajay Baghel · Posted: Tue Jul 20, 2010 6:59 pm

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

chitanya · New User Joined: 25 Jan 2008 Posts: 6 Location: Hyderabad

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

dick scherrer · Posted: Tue Jul 20, 2010 11:37 pm

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.

Anuj Dhawan · Posted: Wed Jul 21, 2010 7:57 pm

With your release of SyncSort, try this for a SyncTool Job -