×

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 thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.