MVSFORUMS.com

rajeev5174 · Beginner Joined: 05 Jun 2007 Posts: 25 Topics: 10

Hi,

The below query when i am trying to execute is giving error of -199, please some one let me know where the issue is.

dbzTHEdinosauer · Posted: Tue May 29, 2012 11:25 am Post subject:

sigh (picked that up from kolusu)

the -199 tells you have a misplaced keyword - what and where.

since you decided to provide only your sql (somewhat unreadable, correctable with code tags)

you are still stuck with solving the problem yourself.

the issue is your not bothering to look up the sql code description and recommended solution.

nothing we can do to help.
_________________
Dick Brenholtz
American living in Varel, Germany

papadi · Supermod Joined: 20 Oct 2009 Posts: 594 Topics: 1

You SELECT . . . . FROM TABLE, but nothing is defined as TABLE . . .

Or my eyes are selectively failing . . . Smile

_________________
All the best,

di

kolusu · Posted: Tue May 29, 2012 4:43 pm Post subject:

rajeev5174,

I added code tags to your post that it is readable. And here is a link for the detailed explanation of the error -199

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/dsnmcj12/2.3.77?

Also take a look at the example 15 which shows how an left outer join is done

rajeev5174 · Beginner Joined: 05 Jun 2007 Posts: 25 Topics: 10

Thanks Kolusu for the info the query is corrected.
Thanks,
Raj