Neoview Command Interface (NCI) Guide (R2.5)

WMS
specifies Workload Management Services (WMS) mode and supports the use of WMS
commands. For a complete description of the WMS commands, see the Neoview Workload
Management Services Guide.
In addition to the WMS commands, WMS mode supports a subset of the NCI commands.
For a list, see Table A-2 (page 96). All other NCI commands are disallowed in WMS mode.
SEC
specifies security mode (SEC) mode and supports the use of all security management
commands. For a complete description of the security management commands, see the
Neoview User Management and Security Administration Guide.
In addition to the security management commands, SEC mode supports a subset of the NCI
commands. For a list, see Table A-2 (page 96). All other NCI commands are disallowed in
SEC mode.
Considerations
You must enter the MODE command on one line. The command does not require an SQL
terminator.
You can execute the MODE command in PRUN script files in addition to OBEY or @ script
files.
To run a command outside of its supported mode, you must precede the command with
the .mode prefix and a space. mode is the name of one of these modes: SQL, CS, NS, WMS,
or SEC. For example, using the .SQL prefix before an SQL statement in WMS mode allows
you to run the SQL statement in WMS mode without having to switch to SQL mode:
WMS>.sql select count(*) from NEO.HP_METRICS.QUERY_STATS_VW2;
If you use the .mode prefix, the command that follows it must be on a single line.
SQL mode supports all NCI commands. However, CS, NS, WMS, and SEC modes support
the subset of the NCI commands in Table A-2 (page 96).
Table A-2 NCI Commands Supported in All Modes
SET COLSEP and SHOW COLSEP
SET CONNECTOPT ROLE
SET HISTOPT and SHOW HISTOPT
SET IDLETIMEOUT and SHOW IDLETIMEOUT
SET MARKUP and SHOW MARKUP
SET PROMPT
SET TIME and SHOW TIME
SET TIMING and SHOW TIMING
SHOW ACTIVITYCOUNT
SHOW ALIAS
SHOW ALIASES
SHOW ERRORCODE
SHOW FETCHSIZE
SHOW RECCOUNT
SHOW ROLE
SHOW STATISTICS
VERSION
@ and OBEY
ALIAS
CLEAR
CONNECT, RECONNECT, DISCONNECT, EXIT,
and QUIT
DELAY
ENV, SESSION, and SHOW SESSION
FC and REPEAT
GOTO
HELP
HISTORY and SAVEHIST
IF...THEN
LABEL
LOCALHOST
LOG and SPOOL
MODE and SHOW MODE
RESET LASTERROR and SHOW LASTERROR
SCHEDULE
96 NCI Commands