Hi,
as it says: You have no column in your result table named backup_end. The
column is named: "Last completed backup".
The sql could be:
select node_name as "Hostname", filespace_name as
"Filespace", date(backup_end) as "Last completed backup" from filespaces
where backup_end<current_timestamp-1 day or backup_end is null order by 3
or it could be:
select node_name as "Hostname", filespace_name as
"Filespace", date(backup_end) as "Last completed backup" from filespaces
where backup_end<current_timestamp-1 day or backup_end is null order by
"Last completed backup"
Allan Hansen
Munk IT A/S
Egelundsvej 18
5260 Odense S
Denmark
Alexander Lazarevich <[EMAIL PROTECTED]>
Sendt af: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
27-08-2003 21:42
Besvar venligst til "ADSM: Dist Stor Manager"
Til: [EMAIL PROTECTED]
cc:
Vedr.: Re: select backup_end - only date?
Still doesn't work:
tsm: XXXXXX>select node_name as "Hostname", filespace_name as
"Filespace", date(backup_end) as "Last completed backup" from filespaces
where backup_end<current_timestamp-1 day or backup_end is null order by
backup_end
ANR2964E The reference 'BACKUP_END' is not a column of the SQL result
table.
.....................................................V.........
rrent_timestamp-1 day or backup_end is null order by backup_end
ANS8001I Return code 3.
If I replace ALL references of backup_end with data(backup_end) it doesn't
work either and gives the following error:
ANR2904E Unexpected SQL key word token - 'DATE'.
I go through the script, no matter what backup_end's are replaced with
date(backup_end), I can't get it to work.
Any other ideas?
Thanks!
Alex
On Wed, 27 Aug 2003, Fred Johanson wrote:
> Try ...date(backup_end) as ...
>
>
> At 02:21 PM 8/27/2003 -0500, you wrote:
> >I've got a tsm script which works fine, but I only want the date from
> >backup_end table, not the time. Anyone know how to get the date only
from
> >backup_end? The time on it is not needed and adds to much clutter to
the
> >email. I can do it in perl, but there must be some way to do it in sql,
> >which I prefer. Statement is below:
> >
> >select node_name as "Hostname", filespace_name as "Filespace",
backup_end
> >as "Last completed backup" from filespaces where
> >backup_end<current_timestamp-1 day or backup_end is null order by
> >backup_end
> >
> >Thanks in advance,
> >
> >Alex
> >--- ---
> > Alex Lazarevich | Systems Administrator | Imaging Technology Group
> > Beckman Institute - University of Illinois
> > [EMAIL PROTECTED] | (217)244-1565 | www.itg.uiuc.edu
> >--- ---
>
