issue in skipping records...



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

issue in skipping records...

Postby SIREESHA » Mon Feb 16, 2009 12:53 pm

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.
SIREESHA
 
Posts: 4
Joined: Mon Feb 16, 2009 12:42 pm
Has thanked: 0 time
Been thanked: 0 time

Re: issue in skipping records...

Postby dick scherrer » Mon Feb 16, 2009 10:28 pm

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?
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: issue in skipping records...

Postby Alissa Margulies » Tue Feb 17, 2009 9:30 pm

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.
Alissa Margulies
Syncsort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com
Alissa Margulies
Global moderator
 
Posts: 369
Joined: Tue Feb 26, 2008 11:15 pm
Location: USA
Has thanked: 1 time
Been thanked: 3 times

Re: issue in skipping records...

Postby SIREESHA » Wed Feb 18, 2009 6:15 pm

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
SIREESHA
 
Posts: 4
Joined: Mon Feb 16, 2009 12:42 pm
Has thanked: 0 time
Been thanked: 0 time

Re: issue in skipping records...

Postby Alissa Margulies » Wed Feb 18, 2009 8:50 pm

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.
Alissa Margulies
Syncsort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com
Alissa Margulies
Global moderator
 
Posts: 369
Joined: Tue Feb 26, 2008 11:15 pm
Location: USA
Has thanked: 1 time
Been thanked: 3 times

Re: issue in skipping records...

Postby SIREESHA » Thu Feb 19, 2009 10:58 am

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.
SIREESHA
 
Posts: 4
Joined: Mon Feb 16, 2009 12:42 pm
Has thanked: 0 time
Been thanked: 0 time

Re: issue in skipping records...

Postby Alissa Margulies » Thu Feb 19, 2009 8:57 pm

Do you know how many records are in the file?
Alissa Margulies
Syncsort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com
Alissa Margulies
Global moderator
 
Posts: 369
Joined: Tue Feb 26, 2008 11:15 pm
Location: USA
Has thanked: 1 time
Been thanked: 3 times

Re: issue in skipping records...

Postby SIREESHA » Fri Feb 20, 2009 9:39 am

No Idea but its very large file
SIREESHA
 
Posts: 4
Joined: Mon Feb 16, 2009 12:42 pm
Has thanked: 0 time
Been thanked: 0 time

Re: issue in skipping records...

Postby dick scherrer » Fri Feb 20, 2009 9:45 am

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. . .
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: issue in skipping records...

Postby Alissa Margulies » Sat Feb 21, 2009 3:23 am

Sireesha,

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

//SYSIN DD *                                                   
   INREC IFTHEN=(WHEN=INIT,OVERLAY=(81:SEQNUM,8,ZD)),           
         IFTHEN=(WHEN=(81,8,ZD,LE,100),OVERLAY=(81:C'99999999')) 
   SORT FIELDS=(81,8,ZD,D),EQUALS                               
   OUTFIL ENDREC=600,OUTREC=(1,80)         
/*
Alissa Margulies
Syncsort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com
Alissa Margulies
Global moderator
 
Posts: 369
Joined: Tue Feb 26, 2008 11:15 pm
Location: USA
Has thanked: 1 time
Been thanked: 3 times


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post