File Utility Programming (FUP) Reference Manual

FUP Commands
File Utility Program (FUP) Reference Manual—523323-015
2-125
LISTLOCKS
required to precede and delimit each ansiname. The ANSI names syntax is in
accordance with Unified Syntax Proposal. The syntax is:
SQL-name
is used to name SQL base objects (such as tables or indexes) in addition to
their SQL containers: catalogs and schemas. The names (called 3-part names)
for SQL base objects such as tables, indexes, or modules are composed of
three SQL identifiers separated by two dot characters (for example,
CAT.SCH.T).
SQL-identifier
is a name used by SQL/MX to identify tables, views, columns, and other SQL
entities. SQL identifiers can be either regular or delimited and can contain up to
258 characters in external form, or equivalently up to 128 characters in internal
format. Regular identifiers begin with a letter (A through Z or a through z), but
can also contain digits (0 through 9), or underscore characters (_).
Regular identifiers used to name a SQL/MX module (the basic object part) can
start with the ^ character or contain the ^ character.
A delimited identifier is enclosed in double quotes ("). Delimited identifiers are
character strings that appear within double quote characters (") and consist of
alphanumeric characters and other characters, except for character @, /,\, and
^. To include a double quote character in a delimited identifier, use two
ansiname :: = CATALOG [SYSTEM | USER ] { * | SQL-names } |
SCHEMA [SYSTEM ] SQL-names |
{TABLE | INDEX} base-mx-object-names
SQL-names :: = SQL-name |( SQL-name [, SQL-name … ]... )
base-mx-object-names :: = base-mx-object-name |
( base-mx-object-name [, base-mx-object-name …] )
base-mx-object-name ::= SQL-name [ partitions ]
partitions :: = PARTITION (SQL-identifier [, SQL-identifier
…]...)
Note. The information regarding SQL/MX module provided above is for reference
purpose only. FUP commands do not support the MODULE keyword.