HP NEOVIEW 544530-001 manual SET Sqlterminator Command, SET Time Command

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