Thanks Richard that is what I was needing to do the select that was required by a customer. Justin
Richard Sims <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 06/03/2004 01:34:12 PM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] cc: Subject: Re: select statement help >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