BookmarkSubscribeRSS Feed
ninachang
Calcite | Level 5
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
1 REPLY 1
Patrick
Opal | Level 21
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

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1302 views
  • 0 likes
  • 2 in conversation