Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Query on omit condition

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

New User


Joined: 01 Apr 2005
Posts: 46

PostPosted: Wed Nov 28, 2007 8:00 pm    Post subject: Query on omit condition
Reply with quote

I have coded the following in a PDS and i used it as control card in the JCL.

The code is as follows:

Code:

  OPTION COPY
  OMIT COND=(1,2,CH,EQ,C'YD',AND,
                 17,2,CH,EQ,C'N0')


In JCL, i used as
Code:

//SYSIN DD DSN=#922148.KKR.CTLLIB(KHR1920R),DISP=SHR


It is giving the folowing srror.

OMIT COND=(1,2,CH,EQ,C'YD',AND,
*
17,2,CH,EQ,C'N0')
*
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

Kiran.
Back to top
View user's profile Send private message

Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Wed Nov 28, 2007 8:09 pm    Post subject:
Reply with quote

SYNCSORT control statements must be blank in column 1.
Back to top
View user's profile Send private message
kiran_65

New User


Joined: 01 Apr 2005
Posts: 46

PostPosted: Wed Nov 28, 2007 8:21 pm    Post subject:
Reply with quote

Thnks for the quick reply

Thanks,
Kiran
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Wed Nov 28, 2007 10:04 pm    Post subject:
Reply with quote

Hi,

Quote:
Thnks for the quick reply

Does that solve your problem, what's the final resolution you used? Can you please share?
Back to top
View user's profile Send private message
kiran_65

New User


Joined: 01 Apr 2005
Posts: 46

PostPosted: Thu Nov 29, 2007 8:41 pm    Post subject:
Reply with quote

it's solved the peoblem.

Once again thanks alot of all help.


But of curiosity, why it should be space in column1

Thanks,
Kiran
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Thu Nov 29, 2007 8:44 pm    Post subject:
Reply with quote

kiran_65 wrote:
But of curiosity, why it should be space in column1
Because that's the rule....... icon_biggrin.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 Join in SQL Query vickey_dw DB2 2 Tue Jan 17, 2017 12:15 am
This topic is locked: you cannot edit posts or make replies. MQ setup query mohitsaini Java & MQSeries 4 Sun Jan 08, 2017 1:53 am
No new posts DB2 query Using Recursion, Converting... smilewithashu2 DB2 1 Tue Jan 03, 2017 12:50 pm
No new posts SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am
This topic is locked: you cannot edit posts or make replies. Db2 SQL query to convert rows into co... subratarec DB2 5 Thu Nov 17, 2016 4:51 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us