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