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

POPULATE INDEX utility
description of, 156
examples of, 85
Port number, default, 53
PREPARE statement
description of, 156
examples of, 70
Procedures
wild-card search, 139
Product banner, 61
Prompts
continuation, 61
standard, 61
PRUN
syntax, 110
Python command line
invoking Neoview Command Interface, 84
running an SQL statement, 85
Python program
including SQL statements, 86
launching Neoview Command Interface, 86
running, 87
Python wrapper script
description of, 84
location of, 41
Q
QUIT command, 113
R
RECONNECT command, syntax of, 113
REORG command
description of, 156
example of, 86
REPEAT command, 114
RESET LASTERROR command, syntax of, 115
RESET PARAM command
examples of, 71
syntax of, 115
RUN command, syntax of, 116
S
Sample script files, 41
SAVEHIST command, syntax of, 117
Schema
setting the current schema, 65
showing all schemas in the default catalog, 65
showing the current schema, 65
wild-card search, 141
Script file
comments, 77
creating, 77
example of, 78
running multiple files in parallel, 79
running one file at a time, 78
running when launching Neoview Command Interface,
58
SELECT statement
description of, 156
example of, 69, 85
Session, 63
SESSION command, syntax of, 142
SET COLSEP command, syntax of, 117
SET commands, in a script file, 58
SET HISTOPTcommand, syntax of, 118
SET IDLETIMEOUT command
example of, 63
syntax of, 119
SET LIST_COUNT command, syntax of, 120
SET MARKUP command, syntax of, 121
SET PARAM command
examples of, 71
syntax of, 124
SET PROMPT command
example of, 63
syntax of, 125
SET SCHEMA statement
description of, 156
example of, 65, 78
SET SQLPROMPT command, syntax of, 127
SET SQLTERMINATOR command
example of, 64
syntax of, 128
SET STATISTICS command
syntax of, 129
SET TIME command
examples of, 63
syntax of, 130
SET TIMING command
examples of, 64
syntax of, 131
SHOW ACCESS command, syntax of, 131
SHOW COLSEP command, syntax of, 132
SHOW HISTOPT command, 132
SHOW IDLETIMEOUT command
example of, 63
syntax of, 133
SHOW LASTERROR command, syntax of, 133
SHOW LIST_COUNT command, syntax of, 134
SHOW MARKUP command, 134
SHOW MODE command, syntax of, 135
SHOW MVGROUPS command, syntax of, 135
SHOW MVS command
example of, 67
syntax of, 136
SHOW PARAM command
example of, 71
syntax of, 138
SHOW PREPARED command, syntax of, 138
SHOW PROCEDURES command, syntax of, 139
SHOW RECOUNT command, syntax of, 140
SHOW SCHEMA command
example of, 65
syntax of, 140
SHOW SCHEMAS command
example of, 65
syntax of, 141
SHOW SESSION command, syntax of, 142
163