Hi, AFAIK the limit is 18 characters on such column names.
Regards, Imre > -----Original Message----- > From: Alexander Lazarevich [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 27, 2003 10:44 PM > To: [EMAIL PROTECTED] > 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 > > > > > [EMAIL PROTECTED] | (217)244-1565 | > www.itg.uiuc.edu > > > > >--- > --- > > > > > > >
