issue in skipping records...

Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL
coder
Posts: 4
Joined: Tue Jul 31, 2007 12:01 am

issue in skipping records...

Postby coder » Tue Jul 31, 2007 12:19 am

hi :D ,

I am just trying to copy few record after skipping some of them.
my JCL looks like,

Code: Select all

000006 //SORTIN   DD DSN=ME.ME395C.G0317V00,                 
000007 //            DISP=SHR                                 
000008 //SORTOUT  DD DSN=UDEM.OE.PZWM4L.TEMP,                 
000009 //            DISP=(NEW,CATLG,DELETE),                 
000010 //            SPACE=(CYL,(600,100),RLSE),UNIT=PERMDA   
000011 //SYSIN    DD *                                       
000012    SORT FIELDS=COPY                                   
000013    SKIPREC=10                                         
000014    STOPAFT=5                                           
000015 /*                                                     

:roll:
but it gives me an error as,

SYSIN :
SORT FIELDS=COPY
SKIPREC=10
*
STOPAFT=5
*
WER275A NO KEYWORDS FOUND ON CONTROL STATEMENT
WER275A NO KEYWORDS FOUND ON CONTROL STATEMENT
WER449I SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE

plz help me to resolve this ...! :ugeek:

William Thompson
Posts: 81
Joined: Sat Jun 09, 2007 4:24 am
Skillset: Some?
Referer: mcmillan
Location: Tucson AZ

Re: issue in skipping records...

Postby William Thompson » Tue Jul 31, 2007 12:33 am

I believe that the SORT operands need to be separated by commas:

Code: Select all

000011 //SYSIN    DD *                                       
000012    SORT FIELDS=COPY,                                   
000013    SKIPREC=10,                                         
000014    STOPAFT=5                                           
000015 /*                                                     

ranga_subham
Posts: 279
Joined: Fri Jul 18, 2008 7:46 pm
Skillset: JCL,COBOL,DB2,IMS/DB,CICS,VSAM
Referer: I was banned by superk in main forum so I am here

Re: issue in skipping records...

Postby ranga_subham » Sat Jan 03, 2009 4:55 pm

Hi,

Suppose if I want to SKIP only a particular record while copying, is it possible to use selectin criteria while skipping records other than OMIT?

Thanks.

CICS Guy
Posts: 246
Joined: Wed Jun 20, 2007 4:08 am

Re: issue in skipping records...

Postby CICS Guy » Sun Jan 04, 2009 12:28 am

ranga_subham wrote:Suppose if I want to SKIP only a particular record while copying, is it possible to use selectin criteria while skipping records other than OMIT?
How do you select that "particular record"? By count? By content?

ranga_subham
Posts: 279
Joined: Fri Jul 18, 2008 7:46 pm
Skillset: JCL,COBOL,DB2,IMS/DB,CICS,VSAM
Referer: I was banned by superk in main forum so I am here

Re: issue in skipping records...

Postby ranga_subham » Mon Jan 05, 2009 8:28 pm

By count only and I don't know how I get the count because file is too huge and giving FIND is taking lot of time !

Thanks.

CICS Guy
Posts: 246
Joined: Wed Jun 20, 2007 4:08 am

Re: issue in skipping records...

Postby CICS Guy » Mon Jan 05, 2009 9:42 pm

INREC with a sequence number, COPY and OMIT the selected count, OUTREC drop the sequence number.....


  • Similar Topics
    Replies
    Views
    Last post