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

R
RECONNECT command, 103
REPEAT command, 103
Reserved schema names, 40
RESET LASTERROR command, 104
RESET PARAM command
examples of, 55
syntax of, 105
RUN command, 105
S
SAVEHIST command, 106
SCHEDULE command, 107
Schema
names (reserved), 40
setting the current schema, 49
showing all schemas in the default catalog, 50
showing the current schema, 49
wild-card search, 137
Script file
comments, 61
creating, 61
example of, 62
running multiple files in parallel, 63
running one file at a time, 62
running when launching Neoview Command Interface,
41
SEC mode, 96
SELECT statement, example of, 53
Session, 47
SESSION command, 138
SET COLSEP command, 109
SET commands, in a script file, 41
SET CONNECTOPT ROLE command, 109
SET FETCHSIZE command, 110
SET HISTOPT command, 111
SET IDLETIMEOUT command
example of, 47
syntax of, 112
SET LIST_COUNT command, 113
SET MARKUP command, 114
SET PARAM command
examples of, 55
syntax of, 117
SET PROMPT command
example of, 47
syntax of, 118
SET SCHEMA statement, example of, 49, 62
SET SQLPROMPT command, 120
SET SQLTERMINATOR command
example of, 48
syntax of, 122
SET STATISTICS command, 122
SET TIME command
examples of, 47
syntax of, 123
SET TIMING command
examples of, 48
syntax of, 124
SHOW ACCESS command, 125
SHOW ACTIVITYCOUNT command, 125
SHOW ALIAS command, 125
SHOW ALIASES command, 126
SHOW COLSEP command, 127
SHOW ERRORCODE command, 127
SHOW FETCHSIZE command, 128
SHOW HISTOPT command, 128
SHOW IDLETIMEOUT command
example of, 47
syntax of, 129
SHOW LASTERROR command, 129
SHOW LIST_COUNT command, 130
SHOW MARKUP command, 130
SHOW MODE command, 131
SHOW MVGROUPS command, 131
SHOW MVS command
example of, 51
syntax of, 132
SHOW PARAM command
example of, 55
syntax of, 134
SHOW PREPARED command, 134
SHOW PROCEDURES command, 135
SHOW RECOUNT command, 136
SHOW ROLE command, 136
SHOW SCHEMA command
example of, 49
syntax of, 137
SHOW SCHEMAS command
example of, 50
syntax of, 137
SHOW SESSION command, 138
SHOW SQLPROMPT command, 140
SHOW SQLTERMINATOR command, 140
SHOW STATISTICS command, 141
SHOW SYNONYMS command
example of, 51
syntax of, 141
SHOW TABLE command
example of, 50
syntax of, 143
SHOW TABLES command
example of, 50
syntax of, 145
SHOW TIME command, 146
SHOW TIMING command, 146
SHOW VIEWS command
example of, 51
syntax of, 146
SPOOL command
examples of, 58
syntax of, 148
Spooling (see Logging output)
SQL mode, 95
SQL parameters
displaying, 55
resetting, 55
setting, 55
187