Got it working, thanks. If my table is called "Last Completed Backup", it
doesn't work. If it's called "Last Backup", it does work. Maybe some kind
of character limit on the table name? Oh well, thanks for the help.

Alex

On Wed, 27 Aug 2003, Fred Johanson wrote:

> I have a similar script which is an extended version of what you want.
>
> select
> filespaces.node_name,filespaces.filespace_name,date(filespaces.backup_end)as
> "Last Backup" from -
>   filespaces where (($1 < -
>   days(current_timestamp) - days(backup_end)) or -
>   backup_end is null) and filespaces.node_name in (select nodes.node_name
> from nodes where domain_name=upper('$2'))
>
> $1 is how many days since and $2 is the domain, but the basic select is there.
>
>
> At 02:42 PM 8/27/2003 -0500, you wrote:
> >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
> > > >        alazarev AT itg.uiuc DOT edu | (217)244-1565 | www.itg.uiuc.edu
> > > >---                                                               ---
> > >
>