>I am in need of some help here I have been asked to come up a way to do a >select to find active and inactive file dates on files. Help would be >appreciated very much.
The following should help you in general: TSM Technical Guide redbook, appendix A "TSM SQL". "Sample SQL Select Statements": http://www.ibm.com/support/entdocview.wss?uid=swg21049808 Beyond that, tell us more about what you specifically need. Richard Sims