NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
V-10
VOLUME Command
The VIEWS table was created in version 1 and there have been no subsequent
modifications.
Guardian names in the VIEWS table (including names of tables and views in the
statements stored in the VIEWTEXT column) are fully qualified. Table and view names
in the VIEWTEXT column are actual file names, never DEFINE names. SQL replaces
any DEFINE names with actual file names at the time you create the view.
All CHAR and VARCHAR columns in the VIEWS table use uppercase characters
except for lowercase string literals specified as part of the search condition in the
VIEWTEXT column. Search conditions that specify the system default multibyte
character set are stored as if you specified the actual character set. (For example, if the
system default multibyte character set is Kanji, the literal N” ....” is stored as
_KANJI”....”.)
VOLUME Command
VOLUME is an SQLCI command that changes the current node, volume, or subvolume
defaults for the SQLCI session. VOLUME also sets the VOLUME attribute of the
=_DEFAULTS DEFINE.
Defaults you set with VOLUME remain in effect until you exit SQLCI or until you enter
a SYSTEM, VOLUME, or ALTER DEFINE that changes the defaults.
\node
specifies the node to be the current default node.
volume
specifies the volume to be the current default volume.
subvol
specifies the subvolume to be the current default subvolume.
5 WITHCHECKOPTION CHAR (1)
Y if defined with WITH CHECK
OPTION
N if not
6 INSERTABLE CHAR (1)
Y if row inserts allowed
N if not
7 VIEWTEXT VARCHAR
(3000)
Text of statement used to define
view
[ \node] ]
VOLUME [ [\node.][$volume] ] ;
[ [\node.][$volume.]subvol ]
Column Name Data Type Description
* Indicates primary key