Neoview Script Guide (R2.2)

SyntaxDescriptionCommand
See the “REPEAT Command”
(page 103).
Reexecutes a command.REPEAT
See the “RESET LASTERROR
Command” (page 105).
Resets the last error code to 0.RESET LASTERROR
See the “RESET PARAM Command”
(page 105).
Clears all parameter values or a
specified parameter value in the
current session.
RESET PARAM
See the “RUN Command” (page 106).Runs the previously executed SQL
statement.
RUN
See the “SAVEHIST Command”
(page 106).
Saves the session history in a
user-specified file.
SAVEHIST
See the “SHOW SESSION Command”
(page 128).
Displays attributes of the current
Neoview Script session.
SESSION
See the “SET COLSEP Command”
(page 107).
Sets the column separator and allows
you to control the formatting of the
result displayed for SQL queries.
SET COLSEP
See the “SET HISTOPT Command”
(page 108).
Sets the history option and controls
how commands are added to the
history buffer.
SET HISTOPT
See the “SET IDLETIMEOUT
Command” (page 109).
Sets the idle timeout value for the
current session.
SET IDLETIMEOUT
See the “SET LIST_COUNT
Command” (page 110).
Sets the maximum number of rows to
be returned by SELECT statements that
are executed after this command.
SET LIST_COUNT
See the“SET MARKUP Command”
(page 111).
Sets the markup format and controls
how results are displayed by Neoview
Script.
SET MARKUP
See the “SET PARAM Command”
(page 113).
Sets a parameter value in the current
session.
SET PARAM
See the “SET PROMPT Command”
(page 114).
Sets the prompt of the current session
to a specified string or to a session
variable.
SET PROMPT
See the “SET SQLPROMPT
Command” (page 116).
Sets the SQL prompt of the current
session to a specified string. The default
is SQL.
SET SQLPROMPT
See the “SET SQLTERMINATOR
Command” (page 117).
Sets the SQL statement terminator of
the current session to a specified string.
The default is a semicolon (;).
SET SQLTERMINATOR
See the “SET TIME Command”
(page 118).
Causes the local time of the client
workstation to be displayed as part of
the interface prompt.
SET TIME
See the“SET TIMING Command”
(page 119).
Causes the elapsed time to be displayed
after each SQL statement executes.
SET TIMING
See the “SHOW COLSEP Command”.Displays the value of the column
separator for the current Neoview
Script session.
SHOW COLSEP
See the “SHOW HISTOPT Command”
(page 120).
Displays the value that has been set for
the history option of the current setting.
SHOW HISTOPT
See the “SHOW IDLETIMEOUT
Command” (page 120).
Displays the idle timeout value of the
current session.
SHOW IDLETIMEOUT
See the “SHOW LASTERROR
Command” (page 121).
Displays the last error of the SQL
statement that was executed.
SHOW LASTERROR
84 Neoview Script Interface Commands