HOW TO GIVE NOT EQUAL CONDITION IN LOOKUP
Posted: Tue Jul 05, 2005 1:20 am
IN CONSTRAINS I GIVINING THIS CONDITION
Feed.HFEDU_ID <> LKPHash.HFEDU_ID
FOR NEW DATA LOAD AND FOR OTHER REJECT ROW
BUT FOR NOT EQUAL, I DON'T KNOW WHY THIS CONDITION IS NOT WORKING EVEN WHEN I AM GIVING Feed.HFEDU_ID = LKPHash.HFEDU_ID FOR REJECT ROW OR CAN SAY REJECT OLD ROW I AM GETTING PROPER RESULT,BUT IN LOG I M GETTING LOTS OF WARNING MESSAGES
can any one suggest me how we can use <> condition so i won't get any warnings in my log.
Feed.HFEDU_ID <> LKPHash.HFEDU_ID
FOR NEW DATA LOAD AND FOR OTHER REJECT ROW
BUT FOR NOT EQUAL, I DON'T KNOW WHY THIS CONDITION IS NOT WORKING EVEN WHEN I AM GIVING Feed.HFEDU_ID = LKPHash.HFEDU_ID FOR REJECT ROW OR CAN SAY REJECT OLD ROW I AM GETTING PROPER RESULT,BUT IN LOG I M GETTING LOTS OF WARNING MESSAGES
can any one suggest me how we can use <> condition so i won't get any warnings in my log.