Specifies whether to enable or disable delimited identifiers. Delimited identifiers are object names enclosed in double quotes. You can use them to avoid certain restrictions on object names. Table, view, and column names can be delimited by quotes; other names cannot.
Delimited identifiers can:
Be reserved words
Begin with non-alphabetic characters
Include characters that ordinarily are not allowed
quoted_identifer=[on | off]
off
on means that a quoted string used as an identifier is recognized.
off means that a quoted string used as an identifier is not recognized as an identifier.
Delimited identifiers follow the conventions for identifiers for DB2.
Before you create or reference a delimited identifier, issue the following statement:
set quoted_identifier on
Each time you use the delimited identifier in a statement, you must enclose it in double quotes. For example:
create table “1one” (col 1 char(3)) create table “include spaces” (col1 int)
or
create table “grant” (“add” int) insert into “grant” (“add”) values (3)
When the quoted_identifier configuration property is turned on, use single quotes, not double quotes, around character or date strings. Delimiting strings with double quotes causes Adaptive Server to treat them as identifiers. The following example shows the correct way to insert a character string into col1 of 1one when the quoted identifier “1one” is turned on:
insert into “1one”(col1) values (‘abc’)
To insert a single quote into a column, use two consecutive single quotation marks. This example shows the correct way to insert the values “a’b” into col1:
insert “1one”(col1) values(‘a”b’)
