DSXchange

Hi All,

Since I'm new to Datastage unable to prepare design for the below one. Please help me:

For Query1 and Query2 I'm not sure how to design the parallel job.

Query1:
SELECT * FROM ABC WHERE XXX IN (SELECT XXX FROM ABC
where STAT = 'CLOSE' AND FLAG = 0 AND TRUNC((sysDate-CURRENTDATE) / 365) >= 2
MINUS
SELECT XXX FROM DEF WHERE LEVEL <> 0 )

Query2:
select * from ABC WHERE XXX IN (SELECT XXX FROM ABC
where STAT='CLOSE' AND FLAG = 0 AND TRUNC((sysDate-CURRENTDATE) / 365) >= 2
MINUS
SELECT XXX FROM FGH WHERE TYPE in ('ggg','hhh')
)

Thanks in Advance

Why not just use these statements as user-defined SQL?

As Ray suggested it is preferable to use user defined sql when fetching data from any database using stages like ODBC,Oracle etc.
your case is a perfect example for such requirements