NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
F-34
FUP Commands and SQL Objects
If you specify fup-command-line, FUP returns you to SQLCI after the command
finishes. If you omit fup-command-line, FUP prompts you for each command and
returns you to SQLCI when you enter the EXIT command.
FUP Commands and SQL Objects
FUP commands work on SQL-compiled object program files but generally do not work
on other SQL objects. Some SQLCI commands perform the same or similar operations
on SQL objects. For example, you can use FILEINFO or FUP INFO with either SQL
objects or Enscribe files, but you must use SQLCI's COPY, DUP, LOAD, PURGE, or
SECURE to operate on SQL objects.
The following table lists the FUP commands that perform operations on files and
indicates whether the commands work with objects other than SQL object programs. For
FUP commands that do not work with SQL objects, the table shows the SQL command
or SQL utility that performs the equivalent function if one exists.
FUP Command
Works on
SQL Objects
Equivalent SQL Command or
NonStop Utility
FUP ALLOCATE No ALTER CATALOG, ALTER INDEX,
ALTER PROGRAM, ALTER TABLE,
ALTER VIEW
FUP ALTER No ALTER CATALOG, ALTER INDEX,
ALTER PROGRAM, ALTER TABLE,
ALTER VIEW
FUP BUILDKEYRECORDS No
FUP CHECKSUM Yes
(only nonaudited)
FUP COPY No COPY utility
FUP CREATE No CREATE TABLE, CREATE INDEX
FUP DEALLOCATE No ALTER CATALOG, ALTER INDEX,
ALTER PROGRAM, ALTER TABLE,
ALTER VIEW
FUP DUP No DUP utility
FUP FILES Yes
FUP GIVE No ALTER CATALOG, ALTER INDEX,
ALTER PROGRAM, ALTER TABLE,
ALTER VIEW, SECURE
FUP INFO Yes
FUP LICENSE Yes
FUP LISTLOCKS Yes
FUP LISTOPENS Yes
(programs only)
FUP LOAD No LOAD
FUP LOADALTFILE No LOAD