Unable to get the correct output for a user-defined SQL

[Tasneem]

Hi all,

I am new to datastage.
The current problem I am facing is that my query executes and gives the desired output when use PL/SQL developer.
But when I paste the Same SQL in the SQL Query section In the Oracle Enterprise section,I get an output with the columns having NULL value.

Is it something to do with the Datastage native SQL .
Please help.

The query is:
SELECT CT.KEY_CODE, CT.CITY_SHORT, CC.THEATER_NR
FROM CITY CT,
(SELECT ship_nr,
key_NUMBER,
key_code,
THEATER_NR
FROM CITY C, THEATRE T
WHERE C.MCITY_NR = T.CITY_NR) CC
WHERE CC.SHIP_NR = CT.KEY_NUMBER AND CT.KEY_CODE = 'D'

[Bala R]

Hi Tasneem,

Did you load the column metadata from oracle table definitions? If you haven't, load the columns definitions and check the data by clicking on view data.
IHTH.

[ray.wurlod]

Welcomae aboard! :D

Make sure also that your link has exactly the three columns defined on it that the query returns; that is KEY_CODE, CITY_SHORT, THEATER_NR.