Re: TSM 6.2 SQL statement

2012-03-08 Thread Clark, Margaret
sday, March 07, 2012 1:40 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] TSM 6.2 SQL statement We run this and other SQL statements that return dates in the form of days. This SQL query works on 5.4, but does not work on 6.2. I am hoping one of the more SQL savvy admins can quickly help me w

Re: TSM 6.2 SQL statement

2012-03-08 Thread Huebner,Andy,FORT WORTH,IT
ite_date))) \> 60 order by last_write_date Thank you, Andy Huebner -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Ankur Patel Sent: Wednesday, March 07, 2012 7:35 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM 6.2 SQL statement Andy,

Re: TSM 6.2 SQL statement

2012-03-07 Thread Ankur Patel
r by last_write_date regards, Ankur Patel > -Original Message- > From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of > Huebner,Andy,FORT WORTH,IT > Sent: Thursday, 8 March 2012 8:40 AM > To: ADSM-L@VM.MARIST.EDU > Subject: [ADSM-L] TSM 6.2 SQL statement >

TSM 6.2 SQL statement

2012-03-07 Thread Huebner,Andy,FORT WORTH,IT
We run this and other SQL statements that return dates in the form of days. This SQL query works on 5.4, but does not work on 6.2. I am hoping one of the more SQL savvy admins can quickly help me with this so I can fix the rest of the queries we use. The lines that don't work and I do not kno