File Utility Programming (FUP) Reference Manual

FUP Commands
File Utility Program (FUP) Reference Manual—523323-015
2-155
RELOAD
SQL-name
is used to name base 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
consecutive double quotes. A delimited module name in SQL/MX can contain
the circumflex character (^).
[ NO ] DEALLOCATE
the default (DEALLOCATE) lets you compact a file and delete all space beyond the
new EOF.
If you select NO DEALLOCATE, the FUP process does not deallocate any extent
beyond the new EOF that is set by RELOAD.
NEW
specifies to perform a new reload operation on filename even if there is a
suspended reload for filename. If NEW is not specified (and a previous reload for
filename was suspended or stopped), FUP restarts the previous operation from
the point where it stopped.
NEW does not override a reload operation in progress. If NEW is specified and a
reload for filename is in progress, FUP displays an error message.
Note. The information regarding SQL/MX module provided above is for
reference purpose only. FUP commands do not support the MODULE
keyword.