Neoview Script Guide (R2.2)

You can continue any SQL statement over multiple lines, breaking that statement at any point
except within a word, a numeric literal, or a multicharacter operator (for example, <=). To break
a string literal in a DML statement, use a concatenation operator (||). For more information, see
the concatenation operator in the Neoview SQL Reference Manual.
To terminate an SQL statement that spans multiple lines, use the SQL terminator for the session.
You can also include several SQL statements on the same command line provided that each one
is terminated by the SQL terminator. For more information, see “Setting and Showing the SQL
Terminator” (page 58).
Case Sensitivity
In the Neoview Script interface, you can enter SQL statements and Neoview Script interface
commands in uppercase, lowercase, or mixed-case characters. All parts of statements and
commands are case-insensitive except for parts that you enclose in single-quotes (') or
double-quotes (").
Using Neoview Script Interface Commands
The Neoview Script interface commands allow you to customize the Neoview Script interface
(for example, by using SET commands) or return information about the interface settings or
database objects (for example, by using SHOW commands):
• “Showing the Session Attributes” (page 56)
• “Setting and Showing the Idle Timeout Value for the Session” (page 57)
• “Customizing the Standard Prompt” (page 57)
• “Setting and Showing the SQL Terminator” (page 58)
• “Displaying the Elapsed Time” (page 58)
• “Setting and Showing the Current Schema” (page 59)
• “Limiting the Result Set of a Query” (page 59)
• “Showing Information About SQL Database Objects” (page 59)
• “Displaying Executed Commands” (page 62)
• “Editing and Reexecuting a Command” (page 62)
• “Clearing the Interface Window” (page 62)
• “Obtaining Help” (page 62)
For more information about the Neoview Script interface commands, see Appendix A (page 83).
NOTE: Each Neoview Script interface command must be entered on one line. If you accidentally
break a Neoview Script interface command across more than one line, enter the SQL terminator
and then reenter the command on one line.
Showing the Session Attributes
To display the attributes and settings of the current Neoview Script session, use the ENV, SHOW
SESSION, or SESSION command. For example, this SESSION command displays the session
attributes:
SQL>session
COLSEP " "
DATASOURCE TDM_Default_DataSource
HISTOPT ALL
IDLETIMEOUT 30 min(s)
LIST COUNT 0 [All Rows]
LOG OFF
LOOK AND FEEL NVS
MARKUP RAW
MODE SQL
PROMPT SQL>
56 Running Commands Interactively in the Neoview Script Interface