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
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,
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
>
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