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'
Unable to get the correct output for a user-defined SQL
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.