Filter
Top Products
description of, 134
examples of, 75, 76
Port number, default, 45
PREPARE statement
description of, 134
examples of, 60
Product banner, 51
Prompts
continuation, 51
standard, 51
PRUN
syntax, 95
Python command line
invoking Neoview Script, 74
running an SQL statement, 75, 76
Python program
including SQL statements, 76
launching Neoview Script, 76
running, 78
Python wrapper script
description of, 74
location of, 34
Q
QUIT command, 97
R
RECONNECT command, syntax of, 98
REORG command
description of, 134
example of, 76
REPEAT command, 98
RESET PARAM command
examples of, 61
syntax of, 99
RUN command, syntax of, 100
S
Sample script files, 34
SAVEHIST command, syntax of, 101
Schema
setting the current schema, 55
showing all schemas in the default catalog, 56
showing the current schema, 55
wild-card search, 121
Script file
comments, 67
creating, 67
example of, 68
running multiple files in parallel, 69
running one file at a time, 68
running when launching Neoview Script, 48
SELECT statement
description of, 134
example of, 59, 75
Session
See Neoview Script session, 53
SESSION command, syntax of, 122
SET COLSEP command, syntax of, 101
SET commands, in a script file, 49
SET HISTOPTcommand, syntax of, 102
SET IDLETIMEOUT command
example of, 53
syntax of, 103
SET LIST_COUNT command, syntax of, 106
SET MARKUP command, syntax of, 104
SET PARAM command
examples of, 61
syntax of, 107
SET PROMPT command
example of, 53
syntax of, 109
SET SCHEMA statement
description of, 134
example of, 55, 68
SET SQLPROMPT command, syntax of, 110
SET SQLTERMINATOR command
example of, 54
syntax of, 112
SET TIME command
examples of, 53
syntax of, 112
SET TIMING command
examples of, 54
syntax of, 113
SHOW COLSEP command, syntax of, 113
SHOW HISTOPT command, 114
SHOW IDLETIMEOUT command
example of, 53
syntax of, 114
SHOW LIST_COUNT command, syntax of, 115
SHOW MARKUP command, 115
SHOW MODE command, syntax of, 116
SHOW MVGROUPS command, syntax of, 116
SHOW MVS command
example of, 57
syntax of, 117
SHOW PARAM command
example of, 61
syntax of, 118
SHOW PREPARED command, syntax of, 119
SHOW SCHEMA command
example of, 55
syntax of, 120
SHOW SCHEMAS command
example of, 56
syntax of, 120
SHOW SESSION command, syntax of, 122
SHOW SQLPROMPT command, 123
SHOW SQLTERMINATOR command, 124
SHOW SYNONYMS command
example of, 57
syntax of, 124
SHOW TABLE command
example of, 56
syntax of, 125
SHOW TABLES command
example of, 56
139