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.