File Utility Programming (FUP) Reference Manual

FUP Commands
File Utility Program (FUP) Reference Manual—523323-015
2-88
INFO
and delimit each ansiname. The ANSI names syntax is in accordance with Unified
Syntax Proposal. The syntax is:
SQL-name
is used to name base SQL 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
consecutive double quotes. A delimited module name in SQL/MX can contain
the circumflex character (^).
DETAIL
gives detailed information on file characteristics (including SMF information). Use
the DISPLAYBITS option (from the CONFIGURE command) with INFO,DETAIL
when the file contains alternate keys containing 8-bit characters.
ansiname ::= {TABLE | INDEX} base-mx-object-names
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.
Note. For more information about the DISPLAYBITS option, see CONFIG[URE]
on
page 2-28.