DS Select not in another table

[selina_king]

Hello, everyone! I am new here. This is my first time post the topic. First allow me thank all the people who answer my question.

I want to select a result from table A, but A. ID NOT IN B. ID.

EXP:
SELECT A.ID,A.NAME FROM A,B WHERE A.ID <> B.ID.

How can I achieve this.

Table A and table B not in the same database.

I want to user 2 DB2 STAGE.

Thank you very much.

[krishnakanth.patil@wipro.]

select ID , Name from A
where ID not in (select Id From B)

[pandeesh]

i guess there should be a db link for achieving this..since both tables are from different databases.. someone correct me if i am wrong..

[rbpty]

You can do this in datastage by doing a lookup on two tables using a lookup stage and then filtering the output of the lookup stage in transformer for null/blank records from the second table. This is like executing a below statement in SQL..

select A.*
from
Table A,
Table B
where
A.ID = B.ID(+) and B.ID is null

[selina_king]

i guess there should be a db link for achieving this..since both tables are from different databases.. someone correct me if i am wrong..

You are right, Two tables not in a same Database. So I want to quary A.ID <>B.ID . Which stage I can use. I do not like lookup stage.

[ray.wurlod]

You will need to use Lookup stage (or, possibly, Merge stage with appropriate unmatched masters handling). What don't you like about Lookup stage?