Filter
Top Products
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 54).
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 52)
• “Setting and Showing the Idle Timeout Value for the Session” (page 53)
• “Customizing the Standard Prompt” (page 53)
• “Setting and Showing the SQL Terminator” (page 54)
• “Displaying the Elapsed Time” (page 54)
• “Setting and Showing the Current Schema” (page 55)
• “Limiting the Result Set of a Query” (page 55)
• “Showing Information About SQL Database Objects” (page 55)
• “Displaying Executed Commands” (page 58)
• “Editing and Reexecuting a Command” (page 58)
• “Clearing the Interface Window” (page 58)
• “Obtaining Help” (page 58)
For more information about the Neoview Script interface commands, see Appendix A (page 79).
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 BTEQ
MARKUP RAW
MODE SQL
PROMPT SQL>
52 Running Commands Interactively in the Neoview Script Interface