Re: Backup reporting: SUMMARY TABLE ISSUE IS FOUND
2002-09-29 15:27:57
select sum(cast( ... as decimal)) Total GB
should become
select sum( ... ) as "Total GB" from summary
Quotes around column headings are important. The "as" keyword too (in fact
Paul also missed it somewhere :)
Zlatko Krastev
IT Consultant
"Chetan H. Ravnikar" <Chetan.Ravnikar AT SYNOPSYS DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
28.09.2002 03:12
Please respond to "ADSM: Dist Stor Manager"
To: ADSM-L AT VM.MARIST DOT EDU
cc:
Subject: Re: Backup reporting: SUMMARY TABLE ISSUE IS FOUND
I get this error running any of the select queries below. any ideas
thanks
==
ANR2905E Unexpected SQL identifier token - 'GB'.
|
.............................................................V.
select sum(cast(bytes/1024/1024/1024 as decimal(6,3))) Total GB
==
...
> >
> > select sum(cast(bytes/1024/1024/1024 as decimal(6,3))) "Total GB
> > Backup" from summary where start_time>=current_timestamp - 1 day and
> > activity='BACKUP'
|
|
|