DB2 Server for VSE & VM: Database Services Utility

Reserved Words

SQL Reserved Words

A list of SQL reserved keywords can be found on SQL Reserved Words. Do not use these words in SQL statements except:

• With their defined meaning in the SQL syntax
• As host variables (preceded by a colon).

In particular, do not use them as names for tables, indexes, columns, views, or dbspaces unless they are enclosed in double quotation marks (").

Database Services Utility Reserved Words

In addition to the SQL reserved keywords, do not use the following keywords in Database Services Utility commands as the name for a table, view, column, or dbspace unless you enclose the name in double quotation marks ("):

Table 6. Names to Avoid Using

DATALOAD	INMOD	RELOAD	SCHEMA
DATAUNLOAD	OUTFILE	REORGANIZE	UNLOAD
INFILE	REBIND

Using Reserved Words as Identifiers

If an identifier is the same as one of the SQL keywords listed in this chapter, you must enclose the name in quotation marks. For example, you can use

"SELECT"

as a name, but if it is not delimited with quotation marks,

SELECT

is interpreted as a keyword.