SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
A-52
Example—ALTER VIEW
Example—ALTER VIEW
These four examples rename, resecure, change the owner of, and change a column
heading for a view,
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. For an SQL table and a non-SQL
object, setting the PARTONLYIN option directs SQL to load from the partition
specified as in-file.
out-file
is the name (or equivalent DEFINE) of an existing entry-sequenced or
key-sequenced SQL table to which to append data. Neither type of file can have
indexes.
recovery-file
is the name (or equivalent DEFINE) of a disk file APPEND creates to hold data for
recovery in case of interruption or failure in restoring out-file to its pre failure
state. RECOVERYFILE is a required parameter and must be the third parameter in
the command string
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] ] ... ;