The following are the reserved words added version 15.0 Adaptive Server:
insensitive – supports scrollable cursors
xmlextract – supports XML services
xmlparse – supports XML services
xmltest – supports XML services
As for all reserved words, the workaround is to use quoted identifiers:
set quoted_identifier on
create table "xmlextract"("xmlparse" int)
You must change all database names that are new reserved words before you can upgrade from an earlier release of the server. You can change table, view, and column names or use delimited identifiers. Once you upgrade to version 15.0, you cannot use database objects whose names are new reserved words until you modify your procedures, SQL scripts, and applications.
Reference Manual Volume: 1 Building Blocks lists all of the reserved words for version 12.5. Reserved words cannot be used as object names or column names.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
