Neoview Script Guide (R2.2)

running, 82
Perl wrapper script
description of, 78
location of, 34
POPULATE INDEX utility
description of, 140
examples of, 79, 80
Port number, default, 47
PREPARE statement
description of, 140
examples of, 64
Procedures
wild-card search, 126
Product banner, 55
Prompts
continuation, 55
standard, 55
PRUN
syntax, 100
Python command line
invoking Neoview Script, 78
running an SQL statement, 79, 80
Python program
including SQL statements, 80
launching Neoview Script, 80
running, 82
Python wrapper script
description of, 78
location of, 34
Q
QUIT command, 102
R
RECONNECT command, syntax of, 103
REORG command
description of, 140
example of, 80
REPEAT command, 103
RESET LASTERROR command, syntax of, 105
RESET PARAM command
examples of, 65
syntax of, 105
RUN command, syntax of, 106
S
Sample script files, 34
SAVEHIST command, syntax of, 106
Schema
setting the current schema, 59
showing all schemas in the default catalog, 60
showing the current schema, 59
wild-card search, 127
Script file
comments, 71
creating, 71
example of, 72
running multiple files in parallel, 73
running one file at a time, 72
running when launching Neoview Script, 52
SELECT statement
description of, 140
example of, 63, 79
Session
See Neoview Script session, 57
SESSION command, syntax of, 128
SET COLSEP command, syntax of, 107
SET commands, in a script file, 52
SET HISTOPTcommand, syntax of, 108
SET IDLETIMEOUT command
example of, 57
syntax of, 109
SET LIST_COUNT command, syntax of, 110
SET MARKUP command, syntax of, 111
SET PARAM command
examples of, 65
syntax of, 113
SET PROMPT command
example of, 57
syntax of, 114
SET SCHEMA statement
description of, 140
example of, 59, 72
SET SQLPROMPT command, syntax of, 116
SET SQLTERMINATOR command
example of, 58
syntax of, 117
SET TIME command
examples of, 57
syntax of, 118
SET TIMING command
examples of, 58
syntax of, 119
SHOW COLSEP command, syntax of, 119
SHOW HISTOPT command, 120
SHOW IDLETIMEOUT command
example of, 57
syntax of, 120
SHOW LASTERROR command, syntax of, 121
SHOW LIST_COUNT command, syntax of, 121
SHOW MARKUP command, 122
SHOW MODE command, syntax of, 122
SHOW MVGROUPS command, syntax of, 122
SHOW MVS command
example of, 61
syntax of, 123
SHOW PARAM command
example of, 65
syntax of, 125
SHOW PREPARED command, syntax of, 125
SHOW PROCEDURES command, syntax of, 126
SHOW SCHEMA command
example of, 59
syntax of, 127
SHOW SCHEMAS command
example of, 60
syntax of, 127
SHOW SESSION command, syntax of, 128
145