Hi All,
We have setup Informix ODBC HS connection to Informix which is running fine.
However there are some sql queries which run into some issue as below.
Scenario
1) First query did not return error. The second one return with error.
No error:
SELECT distinct trim("wafer_lotno"),
(SELECT "wlta_alp_attr_val"
from wiplta@comets wiplta
where wiplta."wlta_lot_number" = ao_master."wafer_lotno" and wiplta."wlta_attr_number" = 12 AND wiplta."wlta_lot_number" = '123' ),
"po_number","launch_date"
FROM ao_master@tandoori ao_master
WHERE "sample" = 'Y' and "ao_status" <> 'D'
Result : return 2672 records
With Error :(after remove AND wiplta."wlta_lot_number" = '123' )
SELECT distinct trim("wafer_lotno"),
(SELECT "wlta_alp_attr_val"
from wiplta@comets wiplta
where wiplta."wlta_lot_number" = ao_master."wafer_lotno" and wiplta."wlta_attr_number" = 12 ),
"po_number","launch_date"
FROM ao_master@tandoori ao_master
WHERE "sample" = 'Y' and "ao_status" <> 'D'
Result : return error
[Error] Script lines: 1-8 --------------------------
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
ORA-02063: preceding line from TANDOORI
2) First query did not return error. The second one return with error.
No error query:
SELECT "launch_date" from ao_master@tandoori ao_master where rownum < 10
SELECT "launch_date" from ao_master@tandoori ao_master where "launch_date" > '2/12/2008'
Error query :
SELECT "launch_date" from ao_master@tandoori ao_master where "launch_date" > '2/12/2008' and rownum < 10
[Error] Script lines: 1-1 --------------------------
ORA-01843: not a valid month
We are not sure why this happen. By removing one condition or combine condition the error happen. If we run the sql command inside Informix itself it is running 100% fine.
Could anyone explain why this is happening.
Thanks
Steven