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

running, 82
Perl wrapper script
description of, 82
location of, 39
POPULATE INDEX utility
description of, 160
Port number, default, 51
PREPARE statement
description of, 160
examples of, 68
Procedures
wild-card search, 143
Product banner, 59
Prompts
continuation, 59
standard, 59
PRUN
syntax, 111
Python command line
invoking Neoview Command Interface, 82
Python program
running, 82
Python wrapper script
description of, 82
location of, 39
Q
QUIT command, 113
R
RECONNECT command, 114
REORG command
description of, 160
REPEAT command, 115
Reserved schema names, 56
RESET LASTERROR command, 116
RESET PARAM command
examples of, 69
syntax of, 116
RUN command, 117
S
Sample script files, 39
SAVEHIST command, 117
Schema
names (reserved), 56
setting the current schema, 63
showing all schemas in the default catalog, 63
showing the current schema, 63
wild-card search, 145
Script file
comments, 75
creating, 75
example of, 76
running multiple files in parallel, 77
running one file at a time, 76
running when launching Neoview Command Interface,
56
SELECT statement
description of, 160
example of, 67
Session, 61
SESSION command, 146
SET COLSEP command, 118
SET commands, in a script file, 56
SET FETCHSIZE command, 119
SET HISTOPT command, 119
SET IDLETIMEOUT command
example of, 61
syntax of, 121
SET LIST_COUNT command, 121
SET MARKUP command, 122
SET PARAM command
examples of, 69
syntax of, 125
SET PROMPT command
example of, 61
syntax of, 127
SET SCHEMA statement
description of, 160
example of, 63, 76
SET SQLPROMPT command, 129
SET SQLTERMINATOR command
example of, 62
syntax of, 130
SET STATISTICS command
syntax of, 131
SET TIME command
examples of, 61
syntax of, 131
SET TIMING command
examples of, 62
syntax of, 132
SHOW ACCESS command, 133
SHOW ACTIVITYCOUNT command, 133
SHOW ALIAS command, 133
SHOW ALIASES command, 134
SHOW COLSEP command, 135
SHOW ERRORCODE command, 135
SHOW FETCHSIZE command, 136
SHOW HISTOPT command, 136
SHOW IDLETIMEOUT command
example of, 61
syntax of, 137
SHOW LASTERROR command, 137
SHOW LIST_COUNT command, 138
SHOW MARKUP command, 138
SHOW MODE command, 139
SHOW MVGROUPS command, 139
SHOW MVS command
example of, 65
syntax of, 140
SHOW PARAM command
example of, 69
syntax of, 141
SHOW PREPARED command, 142
SHOW PROCEDURES command, 143
SHOW RECOUNT command, 144
167