|
View previous topic :: View next topic
|
| Author |
Message |
kedianirmal
New User
.jpg)
Joined: 08 Feb 2008
Posts: 82
Location: Bangalore, India
|
|
|
|
Hi,
I am trying to run a SORT card as below:
| Code: |
//SYSIN DD *
SORT FIELDS=COPY
OUTFIL FILES=01,INCLUDE=((1,4,CH,EQ,C'0010),AND,
((9,7,CH,EQ,C'0003391'),OR,
(9,7,CH,EQ,C'0007863'),OR,
(9,7,CH,EQ,C'0012119'),OR,
(9,7,CH,EQ,C'0031431'),OR,
(9,7,CH,EQ,C'0031875'),OR,
(9,7,CH,EQ,C'0032940'),OR,
(9,7,CH,EQ,C'0034043'),OR,
(9,7,CH,EQ,C'0034494'),OR,
(9,7,CH,EQ,C'0037631'))),BUILD=(1,43)
OUTFIL FILES=02,SAVE |
I am trying to capture the records macthing above criteria in to File 01 and rest all records into 02. The above SORT card is failing with below error
WER268A OUTFIL STATEMENT : SYNTAX ERROR
WER275A NO KEYWORDS FOUND ON CONTROL STATEMENT
WER275A NO KEYWORDS FOUND ON CONTROL STATEMENT
WER275A NO KEYWORDS FOUND ON CONTROL STATEMENT
WER275A NO KEYWORDS FOUND ON CONTROL STATEMENT
WER275A NO KEYWORDS FOUND ON CONTROL STATEMENT
WER275A NO KEYWORDS FOUND ON CONTROL STATEMENT
WER275A NO KEYWORDS FOUND ON CONTROL STATEMENT
WER275A NO KEYWORDS FOUND ON CONTROL STATEMENT
WER275A NO KEYWORDS FOUND ON CONTROL STATEMENT
WER211B SYNCSMF CALLED BY SYNCSORT; RC=0000
WER449I SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE
Can someone help what is the error here?
Thanks,
Nirmal |
|
| Back to top |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix
|
|
| Back to top |
|
|
kedianirmal
New User
Joined: 08 Feb 2008
Posts: 82
Location: Bangalore, India
|
|
|
|
Hi D.Sch
I tried the options in the given post but still its giving the same error message.
This is because I am putting many conditions in INCLUDE condition when I tried with just one it worked. Is there any way to give multiple condition in the INCLUDE?
Regards,
Nirmal |
|
| Back to top |
|
|
superk
Global Moderator
Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA
|
|
|
|
| I don't think you balanced the parentheses correctly. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix
|
|
|
|
Hello,
You did notice that Arun's post uses SYNCTOOL . . . And FNAMES. . . |
|
| Back to top |
|
|
kedianirmal
New User
Joined: 08 Feb 2008
Posts: 82
Location: Bangalore, India
|
|
|
|
Hi SuperK,
Below are the two SORT card i tried:
CTL1CNTL :
OUTFIL FNAMES=OUTFIL1,
INCLUDE=(9,7,CH,EQ,C'0003391')
OUTFIL FNAMES=OUTFIL2,SAVE
CTL1CNTL :
OUTFIL FNAMES=OUTFIL1,
INCLUDE=((9,7,CH,EQ,C'0003391'),AND,
(1,4,CH,EQ,C'0010))
OUTFIL FNAMES=OUTFIL2,SAVE
The first card worked but the second not. again the same error with OUFIL.
The first |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix
|
|
|
|
Hello,
Was something dropped at the end of the last post? Or is there just a spare/extra "The first". . . 
For the second set of control info try this syntax:
| Code: |
INCLUDE=(9,7,CH,EQ,C'0003391',AND,
1,4,CH,EQ,C'0010') |
corrected
I'm not where i can run a test, so this isn't tested. . . |
|
| Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006
Posts: 2482
Location: @my desk
|
|
|
|
Hello,
The problem does not seem to be with SORT/SYNCSORT. I see that you miss a closing quote(') here.
| Quote: |
| (1,4,CH,EQ,C'0010)) |
|
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix
|
|
|
|
Hi Arun,
Good eye
d |
|
| Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006
Posts: 2482
Location: @my desk
|
|
|
|
| Thanks Dick. Have a great weekend |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix
|
|
|
|
Thanks - i did
Just returned from a little road trip. . .
Hope you had a great weekend also 
d |
|
| Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006
Posts: 2482
Location: @my desk
|
|
|
|
| Yes, A long weekend. I'll get back to work only by tomorrow |
|
| Back to top |
|
|
|
|
  |
All times are GMT + 6 Hours |
|
