issue in skipping records...



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

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,

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:
coder
 
Posts: 4
Joined: Tue Jul 31, 2007 12:01 am
Has thanked: 0 time
Been thanked: 0 time

Re: issue in skipping records...

 

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:
000011 //SYSIN    DD *                                       
000012    SORT FIELDS=COPY,                                   
000013    SKIPREC=10,                                         
000014    STOPAFT=5                                           
000015 /*                                                     
William Thompson
 
Posts: 86
Joined: Sat Jun 09, 2007 4:24 am
Location: Tucson AZ
Has thanked: 0 time
Been thanked: 1 time

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.
ranga_subham
 
Posts: 279
Joined: Fri Jul 18, 2008 7:46 pm
Has thanked: 0 time
Been thanked: 1 time

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?
CICS Guy
 
Posts: 255
Joined: Wed Jun 20, 2007 4:08 am
Has thanked: 0 time
Been thanked: 0 time

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.
ranga_subham
 
Posts: 279
Joined: Fri Jul 18, 2008 7:46 pm
Has thanked: 0 time
Been thanked: 1 time

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.....
CICS Guy
 
Posts: 255
Joined: Wed Jun 20, 2007 4:08 am
Has thanked: 0 time
Been thanked: 0 time


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post