Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
How to save rejected records in SYNCSORT

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
kedianirmal

New User


Joined: 08 Feb 2008
Posts: 82
Location: Bangalore, India

PostPosted: Fri Dec 24, 2010 12:13 am    Post subject: How to save rejected records in SYNCSORT
Reply with quote

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
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Dec 24, 2010 12:46 am    Post subject:
Reply with quote

Hello,

Our forum SEARCH is your friend. . .

See if the post from Arun in this topic will help:
http://ibmmainframes.com/viewtopic.php?t=40994&highlight=copy+save
Back to top
View user's profile Send private message
kedianirmal

New User


Joined: 08 Feb 2008
Posts: 82
Location: Bangalore, India

PostPosted: Fri Dec 24, 2010 2:09 am    Post subject:
Reply with quote

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
View user's profile Send private message
superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4650
Location: Raleigh, NC, USA

PostPosted: Fri Dec 24, 2010 2:15 am    Post subject: Reply to: How to save rejected records in SYNCSORT
Reply with quote

I don't think you balanced the parentheses correctly.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Dec 24, 2010 2:25 am    Post subject:
Reply with quote

Hello,

You did notice that Arun's post uses SYNCTOOL . . . And FNAMES. . .
Back to top
View user's profile Send private message
kedianirmal

New User


Joined: 08 Feb 2008
Posts: 82
Location: Bangalore, India

PostPosted: Fri Dec 24, 2010 2:29 am    Post subject:
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Dec 24, 2010 4:06 am    Post subject:
Reply with quote

Hello,

Was something dropped at the end of the last post? Or is there just a spare/extra "The first". . . icon_smile.gif

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
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2296
Location: @my desk

PostPosted: Sat Dec 25, 2010 12:18 pm    Post subject: Reply to: How to save rejected records in SYNCSORT
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sun Dec 26, 2010 4:08 am    Post subject: Reply to: How to save rejected records in SYNCSORT
Reply with quote

Hi Arun,

Good eye icon_smile.gif

d
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2296
Location: @my desk

PostPosted: Sun Dec 26, 2010 1:21 pm    Post subject: Re: Reply to: How to save rejected records in SYNCSORT
Reply with quote

Thanks Dick. Have a great weekend icon_smile.gif
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Dec 27, 2010 10:09 am    Post subject: Reply to: How to save rejected records in SYNCSORT
Reply with quote

Thanks - i did icon_smile.gif

Just returned from a little road trip. . .

Hope you had a great weekend also icon_wink.gif

d
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2296
Location: @my desk

PostPosted: Tue Dec 28, 2010 9:31 am    Post subject:
Reply with quote

Yes, A long weekend. I'll get back to work only by tomorrow icon_wink.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Skip records depends on count lakshmiibmmainframes DFSORT/ICETOOL 5 Sun Dec 24, 2017 9:51 pm
No new posts Compare two PS files using ICE TOOL f... SENTHIL MURUGAAN DFSORT/ICETOOL 5 Sun Dec 24, 2017 1:26 pm
No new posts Inefficient BUILD - VB records paddin... Daniel Prosser SYNCSORT 9 Thu Dec 14, 2017 3:52 pm
No new posts ISSUE IN copying Sequential file reco... thesumitk JCL & VSAM 2 Wed Dec 13, 2017 3:07 pm
No new posts Merging 2 records at multiple rows wi... Bijesh DFSORT/ICETOOL 2 Wed Dec 06, 2017 1:50 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us