The following rules apply when naming objects saved in the database.
Names for queries, forms, procedures, tables, and views must be unique.
(You cannot have a query and a form with the same name.)
Names cannot start with a number.
A name enclosed in double quotation marks can start with any character
except a double quotation mark or a blank.
You can use any character in a QMF object name except the following special characters: . , ; : < > ( ) | + - * / = & ¬ ' "
In some non-English single-byte character sets, the not sign
(¬) displays as a circumflex (^); the vertical bar (|) displays
as an exclamation point (!).
Avoid using the special characters listed above in a name. If you use
any of the special characters in SQL names, you must enclose
the entire name in double quotation marks ("name"). Names
enclosed in double quotation marks can contain any characters (including blanks)
except a double quotation mark. See your SQL reference for rules for using
special characters in SQL names.
A name cannot be longer than 18 characters. However, a name can be qualified by a location identifier of up to 18 characters
and may include a user identifier of up to 8 characters. For example, this
is a fully qualified name:
NEW_YORK.Q.STAFF
It specifies a
table owned by the NEW_YORK location created by the user Q with the name
of STAFF.
Do not use QMF reserved words for names because, when used in a QMF command,
they will never refer to something in the database. The QMF reserved words
are:
CHART FORM QUERY DATA TABLE PROC REPORT FORM PROFILE
Do not use SQL reserved words for names. See your SQL reference for a
list of reserved words.