Hi All,
I have custno,custname,loc columns are there in Customer table.In this i need to check custno is new value or not? if the custno is new value then insert the custno into another table,if the tcustno is already existed value then ignore the custno....
Can you please let me know how to find new or existed?
Find the new value or existing value?
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Do you mean new in the stream of data or new in the database to which you're writing? (Tip: learn to write clear specifications - it will help any career to which you might aspire in IT.)
In the first case sort the stream and generate a key change column.
In the latter case, perform a lookup and set a flag. OR with that flag in subsequent lookups.
In the first case sort the stream and generate a key change column.
In the latter case, perform a lookup and set a flag. OR with that flag in subsequent lookups.
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.