Filter
Top Products
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
• In the Neoview Script interface, 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.
• 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
This query ends with the new terminator, go:
SQL>select * from persnl.employee go
• To reset the SQL terminator to the default, enter this command:
SQL>set sqlterminator ;
For more information, see “Setting and Showing the SQL Terminator” (page 54).
SET TIME Command
The SET TIME command causes the local time of the client workstation to be displayed as part
of the interface prompt. By default, the local time is not displayed in the interface prompt.
Syntax
SET TIME { ON[12H] | OFF }
ON specifies that the local time be displayed as part of the prompt.
OFF specifies that the local time not be displayed as part of the prompt. OFF is the default.
Considerations
In the Neoview Script interface, you must enter the command on one line. The command does
not require an SQL terminator.
112 Neoview Script Interface Commands