Hi,
AFAIK the limit is 18 characters on such column names.
Regards,
Imre
> -----Original Message-----
> From: Alexander Lazarevich [mailto:alazarev AT ITG.UIUC DOT EDU]
> Sent: Wednesday, August 27, 2003 10:44 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: select backup_end - only date?
>
>
> 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
> > > > >---
> ---
> > > >
> >
>
|