s***@centroin.com.br
2007-10-06 21:04:14 UTC
I have access to DB2 database that updates with new information everyday without any regularity on the update hour. The only way to know that the system is current updated with new information is a table inside the system with the "update_date".
I have a local DB2 that I populate everyday a group of tables using this remote system as source. Is there any way to create a local task on my task center to compare the dates ( maybe I can create also local table with the "last_update_date" ) and the date in the remote system ?
What I need is basically a way to compare two dates from differences sources and return true or false.
Regards
Bira
I have a local DB2 that I populate everyday a group of tables using this remote system as source. Is there any way to create a local task on my task center to compare the dates ( maybe I can create also local table with the "last_update_date" ) and the date in the remote system ?
What I need is basically a way to compare two dates from differences sources and return true or false.
Regards
Bira