NOt in look up
Posted: Wed Jul 12, 2006 10:51 pm
Hi Gurus ,
can any one help me
how to implement the following query in DSEE as i am new to Datastage
SELECT distinct col1,col2,col3 FROM tableA
WHERE ( AP > 0 or SP > 0 ) and lf = '01' and
ce = '01' and rd = '00'and col1 not in
( select col1 from tableA where col4 = '01' and
col5 = '01' and col6 = '00' and fdate = 200673 ) and period = 200673
i want to know how to lookup not in records
Thanks in advance
can any one help me
how to implement the following query in DSEE as i am new to Datastage
SELECT distinct col1,col2,col3 FROM tableA
WHERE ( AP > 0 or SP > 0 ) and lf = '01' and
ce = '01' and rd = '00'and col1 not in
( select col1 from tableA where col4 = '01' and
col5 = '01' and col6 = '00' and fdate = 200673 ) and period = 200673
i want to know how to lookup not in records
Thanks in advance