I have two files coming from a client that is is to be compared to a master list we have. We are presently going through the list of names by; last_name,first_name, and Date of Birth, manually to see if the name is on the master list, then we send a report to the the client of any names not listed on master list from sent list. We are using using DB2 for all list, how can I write a macro to automate this process?
Gary T. Payne
Pinned topic Automating a manual assignment
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-11-30T12:14:16Z at 2012-11-30T12:14:16Z by SystemAdmin
SystemAdmin 110000D4XK17917 Posts
Re: Automating a manual assignment2012-11-30T12:14:16ZThis is the accepted answer. This is the accepted answer.Hello,
One of the many options for this is the following :
with SENT(last,first,date_birth)as ( values
select last,first,date_birth from SENT
where (last,first,date_birth) not in (
select last,first,date_birth from MASTER;
Hope this helps.