Neoview Command Interface (NCI) Guide (R2.4)

SQL>set sqlprompt %server>
neo0101.mylab.mycorp.net:18650>
• This command displays the session schema for the prompt:
SQL>set sqlprompt "Schema %schema:"
Schema USR:
• This command displays the session data source for the prompt:
SQL>set sqlprompt "%datasource SQL>"
TDM_Default_DataSource SQL>
• This command displays multiple session variables:
SQL>set sqlprompt %USER@%SCHEMA>
super.super@USR>
nci0101:23000@TDM_Default_DataSource>
SQL>set sqlprompt ”%schema NVSCRIPT> ”
NVSCHEMA NVSCRIPT>
For more information, see “Customizing the Standard Prompt” (page 61).
SET SQLTERMINATOR Command
The SET SQLTERMINATOR command sets the SQL statement terminator of the current session.
The default is a semicolon (;).
Syntax
SET SQLTERMINATOR string
string
is a string value for the SQL terminator. The string may contain any characters except spaces.
Spaces are disallowed even if you enclose the string in double quotes. Lowercase and
uppercase characters are accepted, but the SQL terminator is always shown in uppercase.
Considerations
• You must enter the command on one line. The command does not require an SQL terminator.
• You can execute this command only in SQL mode.
• Do not include SQL or NCI reserved word as an SQL terminator.
• If you execute this command in a script file, it affects not only the SQL statements in the
script file but all subsequent SQL statements that are run in the current session. If you set
the SQL terminator in a script file, reset the default terminator at the end of the script file.
• To reset the default SQL terminator (;), enter this command:
SET SQLTERMINATOR ;
Examples
• This command sets the SQL terminator to a period (.):
SQL>set sqlterminator .
• This command sets the SQL terminator to a word, go:
SQL>set sqlterminator go
130 NCI Commands