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
NOt in look up
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
What's wrong with loading the result from that query into a Lookup File Set, and using the same for performing your lookup? It's unclear from that SQL what key value will be being looked up, but I am confident you know which column that is.
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.
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
Re: NOt in look up
Hi Reddykkreddy wrote: i want to know how to lookup not in records
Do u mean to lookup against the records which are the rejects from the database after executing the query or something else. If you just want to execute the query and do a lookup, you can do that as suggested by Ray and DSguru orelse you have to catch the rejects from the database and do the lookup against it.
Just your last sentence is not clear.
Thanks
Sam