IBM Mainframe Forum

I'm using Sync Tool to copy first 100 records and last 500 records of a file to a output file.
I have the folowing code:

//S1 EXEC PGM=SYNCTOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//IN1 DD DISP=SHR,DSN=---
//OUT1 DD DISP=SHR,DSN=----
//TOOLIN DD *
SUBSET FROM(IN1) TO(OUT1) OUTPUT KEEP FIRST(100) LAST(500)
/*

but this code is not working.

I would like to know an alternative for SUBSET command.
sireesha.

Hello and welcome to the forum,

When you have a question, you should start a new topic for your question rather than reply to some other topic.

What release of Syncsort s used on your system?

SIREESHA,

SUBSET is supported in SyncSort for z/OS 1.3.2.0 (SYNCTOOL release 1.6.2). When you say that the code is not working, what error message are you getting? If it is a syntax error, I suspect that you are running an earlier release of the product.

Hi Alissa,

Iam working with SYNCTOOL RELEASE 1.5.3.
And this is the error message iam getting

SUBSET FROM(IN1) TO(OUT1) OUTPUT KEEP FIRST(100) LAST(500)
STATEMENT DOES NOT BEGIN WITH A VALID OPERATOR
OPERATION COMPLETED WITH RETURN CODE 12

I would recommend that you upgrade to the current version of SyncSort for z/OS, which will include the support for the new SYNCTOOL features.

Thanks for the suggestion Alissa. But Iam working for a SW Company and i do not have any rights to do any upgradations or installations. I have to make use of what i have.
So it would be helpfull if u suggest me any alternative for the above CODE.

Do you know how many records are in the file?

No Idea but its very large file

Hello,

If you use the sort to simply "copy" the file and direct the output of the copy to a DD DUMMY, the output will show the record count. . .

"Very large" has different meanings in different environments. We'd probably all agree that a billion records is very large. How about 1million or 10 million? Some places have no files that big while 100 million is about average for several of the processes i support. . .

Sireesha,

Assuming that the file is FB/80, try this code: