NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
F-35
Considerations—FUP
You can also use ALLOW, CTRL-Y, EXIT, FC, HELP, RESET, SET, SHOW, SYSTEM,
and VOLUME to perform operations on files. When you return to SQLCI, the default
system and volume are those that were in effect when you invoked FUP.
If a table or view is encountered during the processing of a FUP command that does not
support SQL objects, the table or view is skipped and a warning message is issued.
Considerations—FUP
•
If you use FUP DUP to duplicate an object program, the SQL SENSITIVE and SQL
VALID flags in the file label of the new file are turned off, and you receive a
warning message that the file must be compiled by SQL.
•
If you apply the FUP LICENSE command to an SQL object program file, the file is
licensed. This method is the only way to license an SQL object program file.
•
You can display information about Enscribe files and SQL objects by using either
the FUP INFO command or the SQL FILEINFO utility. The only significant
difference between the two utilities is that the fileset-list parameter of FUP
INFO does not support the FROM CATALOG option and does not handle wild-card
characters in the same way as the qualified-fileset-list parameter of the
SQL FILEINFO utility.
Examples—FUP
•
The following command displays the files on the current subvolume:
>> FUP FILES;
$VOL1.DFLT
A1 A2 A3 A4
FUP PURGE Yes
(programs only)
DROP, PURGE
FUP PURGEDATA No PURGEDATA
FUP RELOAD Yes
FUP RENAME No
FUP REVOKE No
FUP SECURE No ALTER CATALOG, ALTER INDEX,
ALTER PROGRAM, ALTER TABLE,
ALTER VIEW, SECURE
FUP Command
Works on
SQL Objects
Equivalent SQL Command or
NonStop Utility