Good News Everybody!
The new search engine is LIVE!
Please report any problems to david (at) midrange.com.
|
I'm trying to setup SQL->XML in WDSC. In order to do that, I must first define
my SQL statement. I'm doing that by typing it in directly, but when I try to
"Parse" I receive an error. The statement has been greatly simplified but still
fails:
select a.*,c.*
from DISTV3.BASE_ST as a
left outer join DISTV3.REL_ST_STF_1M as b
on a.stkey=b.stkey
left outer join DISTV3.BASE_STF as c
on b.stfkey=c.stfkey
If I eliminate the second join, it parses. Otherwise, I get "IWAW0584E: Parse
error encountered...com.ibm.etools.ddl2xmi.DDL2XMIException: IWAS0035E The
table: '...whole SQL statement here...' cannot be found. I googled both errors
and got nothing.
Any ideas on what I'm doing wrong? The statement works fine in interactive SQL
on the system.
.
NOTICE: This E-mail may contain confidential information. If you are not
the addressee or the intended recipient please do not read this E-mail
and please immediately delete this e-mail message and any attachments
from your workstation or network mail system. If you are the addressee
or the intended recipient and you save or print a copy of this E-mail,
please place it in an appropriate file, depending on whether
confidential information is contained in the message.
This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.