Taking a particular word from particular row using SORT



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

Re: Taking a particular word from particular row using SORT

Postby BillyBoyo » Thu Nov 28, 2013 6:05 pm

  OUTFIL BUILD=(6,10,80:X),VTOF


This will put a blank at column 80, and pad any intervening columns with space.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Re: Re: Taking a particular word from particular row using SORT

 

Re: Taking a particular word from particular row using SORT

Postby sange-sherin » Mon Dec 02, 2013 1:12 pm

Hi BillyBoyo,

I am facing error the follwoing error :
********************************* TOP OF DATA
 STMT NO. MESSAGE                             
       13 IEFC630I UNIDENTIFIED KEYWORD DIPS 
******************************** BOTTOM OF DAT


MY SORT JCL:


 //SORT1 EXEC PGM=SORT                                         
 //SYSOUT  DD SYSOUT=*                                         
 //SORTIN  DD DSN=BEJGB2.X186625.CONTROL.D131125.TEST2,DISP=SHR
 //SORTOUT  DD DSN=BEJGB2.X186625.SORT.D131202.TEST2,DIPS=OLD   
 //SYSIN   DD *                                                 
   OPTION COPY                                                 
     INCLUDE COND=(5,1,CH,EQ,C'T')                             
      OUTFIL BUILD=(2,10,80:X),VTOF                             
 /*                                                             


can you please provide me the solution?
sange-sherin
 
Posts: 25
Joined: Thu Nov 21, 2013 6:56 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Taking a particular word from particular row using SORT

Postby NicC » Mon Dec 02, 2013 3:12 pm

Sorry, but that is SO obvious that you should not have posted. Please analyse your failures. You just have to compare with what you wrote earlier to resolve the error. I usually have the error as DSIP. Anyway, topic locked. (And unlocked!)
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2690
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 105 times

Re: Taking a particular word from particular row using SORT

Postby BillyBoyo » Mon Dec 02, 2013 4:44 pm

It's just getting stuck in a groove. Happens. Kick yourself afterwards. No biggie.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Re: Taking a particular word from particular row using SORT

Postby dick scherrer » Mon Dec 02, 2013 8:36 pm

Hello,

One thing to "take away" from this is that a JCL error has nothing to do with which sort product (or any other program) was intended to run.

This is another reason that all should learn and use proper terminology . . .

As BB said - don't beat your self up - learn and move on.

d
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: Taking a particular word from particular row using SORT

Postby ranga_subham » Wed Dec 11, 2013 3:44 pm

which one of below SORT cards are optimised for this question and why?

Solution-1:
//SYSIN    DD *                             
 SORT FIELDS=COPY                           
 OUTFIL INCLUDE=(1,1,CH,EQ,C'T'),BUILD=(2,10)


Solution-2:
//SYSIN    DD *               
 SORT FIELDS=COPY             
 INCLUDE COND=(1,1,CH,EQ,C'T')
 OUTREC BUILD=(2,10)         


Thanks.
ranga_subham
 
Posts: 279
Joined: Fri Jul 18, 2008 7:46 pm
Has thanked: 0 time
Been thanked: 1 time

Re: Taking a particular word from particular row using SORT

Postby BillyBoyo » Wed Dec 11, 2013 7:34 pm

INCLUDE COND operates at the start of processing a record. INCLUDE= operates at the end of processing. So solution 2 is more efficient, but you don't have a lot of processing anyway.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Previous

Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post