Re: Backup reporting: SUMMARY TABLE ISSUE IS FOUND

[Zlatko Krastev/ACIT]

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" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
28.09.2002 03:12
Please respond to "ADSM: Dist Stor Manager"


        To:     [EMAIL PROTECTED]
        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'