Help using Base SAS procedures

check DB2 update date

Reply
New Contributor
Posts: 3

check DB2 update date

Hi ,

I have to read a daily refresh DB2 table on my mainfram SAS. Is there
any way to be sure the db2 table is updated or not before reading in?


I tried proc contents, but the last modified date is missing. Thanks
for your help in advance.


Yi
Respected Advisor
Posts: 4,173

Re: check DB2 update date

Posted in reply to ninachang
Hi

I believe a 'last modified date" for tables is something DB2 doesn't maintain and though SAS can't retrieve this information for the dictionnary tables.

What's done for most ETL's is either populating a row per table with a "last modified date" and/or maintain a control table where you store your when, with what data and what return codes you've run your code.

HTH
Patrick
Ask a Question
Discussion stats
  • 1 reply
  • 270 views
  • 0 likes
  • 2 in conversation