Re: ROLLUP Reserved word

#1

Both CUBE and ROLLUP are reserved words; they are part of the OLAP
support in version 9.

Glenn

Michael Gould wrote:

Quote:

I see that ROLLUP is in the reserved word list, but I can't find any
documentation in the help file on what ROLLUP actually is being used for.
The only place that it shows up is in the reserved word list. I'm using the
lastest EFB build of 8.0.2.

Thanks

Michael Gould

--
Glenn Paulley
Research and Development Manager, Query Processing
iAnywhere Solutions Engineering

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

#2

I think it's one of those OLAP functions.

#3

You are correct - it appears that ROLLUP is not known as a keyword in
our ODBC driver, though it is a reserved word in the engine.

This is being looked at in Engineering - hopefully we'll have a fix shortly.

Glenn

Michael Gould wrote:

Quote:

Glenn,

It looks like at least ROLLUP wasn't added to the list of reserved words in
ASA 8 or 9.

The programmer who handles the drivers for the Clarion language is using
SQLGetInfo passing SQL_Keywords as the parameter. He told me that ROLLUP
isn't included in either ASA 8 or 9. In order for him to automatically
double quote those words they need to be in the list.

Thanks

Michael Gould

SQLGetInfo passing SQL_KEYWORDS

"Glenn Paulley" <paulley (AT) ianywhere (DOT) com> wrote in message
news:3fd4ac18 (AT) forums-1-dub (DOT) ..

Both CUBE and ROLLUP are reserved words; they are part of the OLAP
support in version 9.

Glenn

Michael Gould wrote:

I see that ROLLUP is in the reserved word list, but I can't find any
documentation in the help file on what ROLLUP actually is being used

for.

The only place that it shows up is in the reserved word list. I'm using

the

lastest EFB build of 8.0.2.

Thanks

Michael Gould

--
Glenn Paulley
Research and Development Manager, Query Processing
iAnywhere Solutions Engineering

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the

iAnywhere

Developer Community at www.ianywhere.com/developer

--
Glenn Paulley
Research and Development Manager, Query Processing
iAnywhere Solutions Engineering

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: ROLLUP Reserved word

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general

Re: ROLLUP Reserved word - 12-08-2003 , 10:51 AM

Re: ROLLUP Reserved word - 12-08-2003 , 10:52 AM

Re: ROLLUP Reserved word - 12-11-2003 , 03:50 PM