Subject | problems with joins involving stored procedures |
---|---|
Author | gbien@intekom.co.za |
Post date | 2001-05-31T04:33:33Z |
Hi,
Are there any known problems using joins involving
stored procedures in IBO 3.6?? The following sql
(and others) causes IBConsole (vers 1.0.0.326) and
ib_wisql to hang and the server to terminate
abnormally. Whereas they work ok with some other tools.
SELECT
C.WIDECUSTOMERID,
A.*
FROM
AR_AGING('%','1/1/2001') A INNER JOIN CUSTOMER C ON
A.CUSTOMERID = C.CUSTOMERID
ORDER BY 1
Geoff
Are there any known problems using joins involving
stored procedures in IBO 3.6?? The following sql
(and others) causes IBConsole (vers 1.0.0.326) and
ib_wisql to hang and the server to terminate
abnormally. Whereas they work ok with some other tools.
SELECT
C.WIDECUSTOMERID,
A.*
FROM
AR_AGING('%','1/1/2001') A INNER JOIN CUSTOMER C ON
A.CUSTOMERID = C.CUSTOMERID
ORDER BY 1
Geoff