MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

COMPILE TIME ERROR IN SQL QUERY

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database
View previous topic :: View next topic  
Author Message
shekar123
Advanced


Joined: 22 Jul 2005
Posts: 528
Topics: 90
Location: Bangalore India
PostPosted: Sat Sep 10, 2005 6:36 am    Post subject: COMPILE TIME ERROR IN SQL QUERY Reply with quote
Hai,

I am coding SQL queries in my program with host variables and i am quite confident that all the queries are simple and correctly coded.But when i am compiling i am getter compile time error saying

DSNH104I DSNHPARS ILLEGAL SYMBOL ",". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: FOR FOR WITH FETCH ORDER UNION EXCEPT
QUERYNO OPTIMIZE


Same message on line:



Can anyone help me out what exactly do we mean by the significance of the error.
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
PostPosted: Sat Sep 10, 2005 7:15 am    Post subject: Reply with quote
Quote:

DSNH104I DSNHPARS ILLEGAL SYMBOLb ",". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: FOR FOR WITH FETCH ORDER UNION EXCEPT


Shekhar123,

The message is self explanatory. You have an extra comma or a comma in the wrong place in your SQL statement. So correct it.

Also remember that it is better to show us the code for which you are getting the error.

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
bauer
Intermediate


Joined: 10 Oct 2003
Posts: 317
Topics: 50
Location: Germany
PostPosted: Wed Sep 14, 2005 5:23 am    Post subject: Reply with quote
Kolusu,

Quote:

So correct it


your answers are always short and perfect Smile !!!!!
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group