https://communities.sas.com/t5/SAS-Procedures/check-DB2-update-date/m-p/18616#M3692 Hi , <BR /> <BR /> I have to read a daily refresh DB2 table on my mainfram SAS. Is there <BR /> any way to be sure the db2 table is updated or not before reading in? <BR /> <BR /> <BR /> I tried proc contents, but the last modified date is missing. Thanks <BR /> for your help in advance. <BR /> <BR /> <BR /> Yi Tue, 21 Jun 2011 23:41:20 GMT ninachang 2011-06-21T23:41:20Z https://communities.sas.com/t5/SAS-Procedures/check-DB2-update-date/m-p/18616#M3692 Hi , <BR /> <BR /> I have to read a daily refresh DB2 table on my mainfram SAS. Is there <BR /> any way to be sure the db2 table is updated or not before reading in? <BR /> <BR /> <BR /> I tried proc contents, but the last modified date is missing. Thanks <BR /> for your help in advance. <BR /> <BR /> <BR /> Yi Tue, 21 Jun 2011 23:41:20 GMT https://communities.sas.com/t5/SAS-Procedures/check-DB2-update-date/m-p/18616#M3692 ninachang 2011-06-21T23:41:20Z https://communities.sas.com/t5/SAS-Procedures/check-DB2-update-date/m-p/18617#M3693 Hi <BR /> <BR /> 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.<BR /> <BR /> 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.<BR /> <BR /> HTH<BR /> Patrick Wed, 22 Jun 2011 01:13:38 GMT https://communities.sas.com/t5/SAS-Procedures/check-DB2-update-date/m-p/18617#M3693 Patrick 2011-06-22T01:13:38Z