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;
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
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
