NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
A-47
Examples—ALTER VIEW
The following dependencies apply when you alter view security attributes:
Examples—ALTER VIEW
•
The following four statements rename, resecure, change the owner of, and change a
column heading for a view, in that order:
ALTER VIEW NAME1 RENAME NAME2;
ALTER VIEW NAME2 SECURE "nnno";
ALTER VIEW NAME2 OWNER 12,72;
ALTER VIEW NAME2 COLUMN DESCR HEADING "Product/Descriptions";
APPEND Command
APPEND is an SQLCI utility that appends data from an SQL table or Guardian file
(such as a Guardian process, device, unstructured disk file, or Enscribe file) to an entry-
sequenced or key-sequenced SQL table. Neither type of SQL table can have indexes.
APPEND adds data to the end of a table or partition. Unlike SQLCI LOAD, it does not
overwrite data in the target table.
in-file
is the name (or equivalent DEFINE) of the table or file from which to append data.
in-file can be a Guardian process, device (such as a terminal or tape),
unstructured disk file, Enscribe file, or SQL table.
OWNER and
SECURE
A change in the ownership of a view affects the interpretation
of the security string. The security string is interpreted at run
time against the new owner and, if applicable, a new group.
If another process is using a view when the owner or security
string is changed, the process might not be able to access the
view after the view is closed.
SECURE A security string must ensure that users who have write access
also have read access.
Caution. When appending data to an entire table, APPEND requires that you turn off auditing
for the table. Doing so invalidates TMF online dumps of the table. To ensure TMF volume
recovery protection for the table, turn AUDIT back on when the APPEND operation is
complete, and make new TMF online dumps of all table partitions.
When you use the PARTONLY option to append data to a single partition, you do not need to
turn off auditing, as the command does it for you. You still need to make an online dump of the
single partition.
APPEND in-file, out-file, RECOVERYFILE recovery-file
[ [,] [append-option] ] ... ;