DataSTage 8 and Oracle 8i LEFT OUTER JOIN

[mamir_30]

The following SQL is sent from ODBC stage in DataStage8 to an Oracle 8i database. I know Oracle 8 is not supported by DataStage 8.0. I get the following message:"Data source is empty". Any work around this problem? This SQL works fine when issued from TOAD.
Unix/Oracle wire protocol is used instead of Oracle client.

SELECT DISTINCT A.SAMPLE_DTTM SAMPLE_DTTM,A.DTTM_SEQ_ID DTTM_SEQ_ID,A.HOUR HOUR,A.TIME_FRAME TIME_FRAME,
B.LOAD_DATE LOAD_DATE,B.SAMPLE_DTTM SAMPLE_DTTM2
FROM TSTKPI.RMS_SRCDATA B ,TSTKPI.TIME_PERIOD A
WHERE B.SAMPLE_DTTM=A.SAMPLE_DTTM(+)
AND B.TIME_FRAME=A.TIME_FRAME(+)
AND B.LOAD_DATE >= SYSDATE-1
AND B.load_date <= SYSDATE
ORDER BY A.SAMPLE_DTTM

Any help is appreciated.

[ray.wurlod]

Try using ODBC standard grammar (not Oracle specific) to specify the joins.

SELECT DISTINCT A.SAMPLE_DTTM SAMPLE_DTTM,A.DTTM_SEQ_ID DTTM_SEQ_ID,A.HOUR HOUR,A.TIME_FRAME TIME_FRAME,
B.LOAD_DATE LOAD_DATE,B.SAMPLE_DTTM SAMPLE_DTTM2
FROM TSTKPI.RMS_SRCDATA B LEFT OUTER JOIN TSTKPI.TIME_PERIOD A
ON B.SAMPLE_DTTM=A.SAMPLE_DTTM AND B.TIME_FRAME=A.TIME_FRAME
WHERE B.LOAD_DATE >= SYSDATE-1 AND B.load_date <= SYSDATE
ORDER BY A.SAMPLE_DTTM