Need Help in parallel Job design for below logic

HemaV · Post by **HemaV** » Thu Oct 13, 2011 3:46 am

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

ray.wurlod · Post by **ray.wurlod** » Thu Oct 13, 2011 1:01 pm

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

deeplind07 · Post by **deeplind07** » Mon Oct 17, 2011 5:27 am

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