× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. October 2010

Re: Remove Old members from a physical file

Good thought!

SELECT SYSTEM_TABLE_SCHEMA, SYSTEM_TABLE_NAME, SYSTEM_TABLE_MEMBER,
LAST_CHANGE_TIMESTAMP
FROM syspartitionstat
WHERE SYSTEM_TABLE_SCHEMA='ROB' AND SYSTEM_TABLE_NAME='QPGMSRC'
and date(last_change_timestamp)>current date - 300 days


LIBRARY FILE SYSTEM_TABLE_MEMBER LAST_CHANGE_TIMESTAM
NAME NAME P
ROB QPGMSRC SKELETONC 2009-12-22-09.05.17.000000
ROB QPGMSRC A01 2009-12-22-08.31.12.000000
ROB QPGMSRC A 2009-12-14-16.17.57.000000
ROB QPGMSRC SQLSAMPLE 2009-12-17-11.06.24.000000
ROB QPGMSRC AA2 2010-01-12-14.39.23.000000
ROB QPGMSRC ML1 2010-01-18-14.28.02.000000
ROB QPGMSRC ML2 2010-01-18-14.24.17.000000
ROB QPGMSRC ML3 2010-01-18-14.28.44.000000
ROB QPGMSRC S813C5V7 2010-01-22-09.56.57.000000
ROB QPGMSRC A1SQL 2010-02-10-13.22.15.000000
ROB QPGMSRC A1SQL2 2010-02-10-11.16.17.000000
ROB QPGMSRC JARED 2010-02-24-16.42.05.000000
ROB QPGMSRC TROY 2010-06-30-14.48.23.000000


Rob Berendt

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.