try putting dbname..table name
-----Original Message-----
From: Bhandari, Sona [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 14, 2002 1:28 PM
To: CF-Talk
Subject: Joining tables across 2 DB2 databases
I'm currently running the SQL below on the mainframe against a two DB2
databases and it works fine. However, when I run the same
query in COLD FUSION, it hangs up. Can Cold Fusion handle joining 3 tables
across two DB2 databases even with the same datasource? Could there be
something wrong with my query? Thanks for your help.
SELECT COUNT(A.ALPHA_POSN_CD), C.OCD, A.ALPHA_POSN_CD
>From MSHAREA.HRPOSNRF A, MCASA.TA B, MSHAREA.TKNUMRF C
Where A.HR_POSN_CD = B.HR_POSN_CD and
B.TKNUM = C.TKNUM and
A.ALPHA_POSN_CD IN ('01', '02', '03', '04') and
C.OCD IN ('A01', 'E99')
Group by C.OCD, A.ALPHA_POSN_CD;
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
