OUTFIL BUILD=(6,10,80:X),VTOF
This will put a blank at column 80, and pad any intervening columns with space.
Taking a particular word from particular row using SORT
Re: Taking a particular word from particular row using SORT
by BillyBoyo » Thu Nov 28, 2013 6:05 pm
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: 265 times
Re: Taking a particular word from particular row using SORT
by sange-sherin » Mon Dec 02, 2013 1:12 pm
Hi BillyBoyo,
I am facing error the follwoing error :
MY SORT JCL:
can you please provide me the solution?
I am facing error the follwoing error :
********************************* TOP OF DATA
STMT NO. MESSAGE
13 IEFC630I UNIDENTIFIED KEYWORD DIPS
******************************** BOTTOM OF DAT
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
/*
//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
by 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
Regards
Nic
- NicC
- Global moderator
- Posts: 3025
- Joined: Sun Jul 04, 2010 12:13 am
- Location: Pushing up the daisies (almost)
- Has thanked: 4 times
- Been thanked: 136 times
Re: Taking a particular word from particular row using SORT
by 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: 265 times
Re: Taking a particular word from particular row using SORT
by 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
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
-
dick scherrer - Global moderator
- Posts: 6268
- Joined: Sat Jun 09, 2007 8:58 am
- Has thanked: 3 times
- Been thanked: 93 times
Re: Taking a particular word from particular row using SORT
by ranga_subham » Wed Dec 11, 2013 3:44 pm
which one of below SORT cards are optimised for this question and why?
Solution-1:
Solution-2:
Thanks.
Solution-1:
//SYSIN DD *
SORT FIELDS=COPY
OUTFIL INCLUDE=(1,1,CH,EQ,C'T'),BUILD=(2,10)
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)
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
by 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: 265 times
-
- Related topics
- Replies
- Views
- Last post
-
- Performace Tunning - SORT is taking around 5 CPU mints.
by usp343 » Wed May 15, 2013 1:36 am - 7 Replies
- 1793 Views
- Last post by NicC
Wed May 15, 2013 5:47 pm
- Performace Tunning - SORT is taking around 5 CPU mints.
-
- Find a word and replace with spaces till the end of field
by coollearner » Fri Oct 05, 2012 4:27 pm - 1 Replies
- 1924 Views
- Last post by BillyBoyo
Fri Oct 05, 2012 4:32 pm
- Find a word and replace with spaces till the end of field
-
- expand a binary field from half word to full using syncsort
by raja1128 » Fri Jan 23, 2009 11:01 pm - 2 Replies
- 2132 Views
- Last post by Alissa Margulies
Sat Jan 24, 2009 2:40 am
- expand a binary field from half word to full using syncsort
-
- sort with more than 2500 sort conditions
1, 2by shivkumar » Fri Oct 26, 2007 11:27 am - 10 Replies
- 18378 Views
- Last post by arunprasad.k
Tue Mar 04, 2008 1:46 pm
- sort with more than 2500 sort conditions
-
- Sort within Sort
by ranga_subham » Mon Sep 29, 2008 7:06 pm - 6 Replies
- 3023 Views
- Last post by ranga_subham
Wed Oct 01, 2008 3:14 pm
- Sort within Sort