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 3

The result of an SQL query against a table, is always another table.
IN this case, "3" means to order using the 3rd column of the resulting query
table.
If you wanted to order by hostname, you would say "order by 1", since that's
the
first column you asked for.



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
> >        alazarev AT itg.uiuc DOT edu | (217)244-1565 | www.itg.uiuc.edu
> >---                                                               ---
>