SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
N-3
Names
By default, SQL resolves names in a static SQL statement at program startup, resolves
names in a prepared statement at the time the PREPARE or EXECUTE IMMEDIATE
executes, and resolves names in a non-prepared SQLCI statement at the time you
enter the statement. However, if a CONTROL QUERY BIND NAMES AT EXECUTION
directive is in effect at a statement's compilation, preparation, or entry (for static,
prepared, or SQLCI statements, respectively), then SQL resolves names in the
statement at the time the statement executes instead.
For more information about changing the time at which names are resolved, see
CONTROL QUERY Directive on page C-74. For information about the resolution of
DEFINE names, see DEFINEs on page D-27. For information about name resolution in
host programs and the relationship between name resolution and various compilation
options, see the SQL/MP Programming Manual for COBOL or the SQL/MP
Programming Manual for C.
Names
NonStop SQL/MP uses six main types of names:

SQL identifiers

Guardian names

OSS names

Host identifiers

DEFINE names

Catalog names
Rules for SQL identifiers, host identifiers, Guardian names, and OSS names are
described in separate entries for those topics. Rules for DEFINE names and catalog
names are described in the entries for DEFINEs on page D-27, and Catalogs on
page C-8.
Rules for names of other entities used in NonStop SQL/MP are described in terms of
these six types of names. For example, a table name is a Guardian name, the name of
a prepared statement is an SQL identifier, and so forth.
Generally, the rules for naming an entity used by NonStop SQL/MP are described in
the main entry that describes that entity. For example, the rules for table names are
described in Tables on page T-1, and the rules for naming prepared statements are
described in PREPARE Statement on page P-25.
Case is generally not significant in SQL/MP names, although it is significant in names
of host variables in the C programming language, in string literals, and in the c89
command.
For more information, see the entry for a specific type of name.