>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