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

SQL>select * from persnl.employee
where salary = ?sal
and jobcode = ?job;
EMPNUM FIRST_NAME LAST_NAME DEPTNUM JOBCODE SALARY
------ --------------- -------------------- ------- ------- ----------
72 GLENN THOMAS 3300 100 80000.00
--- 1 row(s) selected.
SQL>
NOTE: The names of the named parameters, ?sal and ?job, in the SELECT statement
are identical to the parameter names, sal and job, in the SET PARAM command.
For more information, see “Setting Parameters” (page 69).
SET PROMPT Command
The SET PROMPT command sets the prompt of the current session to a specified string and/or
to these session variables: %USER, %MODE, %SERVER, %SCHEMA, or %DATASOURCE. In
SQL mode, the default prompt is SQL>. In CS mode, the default prompt is CS#.
Syntax
SET PROMPT [string] [%USER] [%MODE] [%SERVER]
[%SCHEMA] [%DATASOURCE]
string
is a string value to be displayed as the prompt. The string may contain any characters. Spaces
are allowed if you enclose the string in double quotes. If you do not enclose the string in
double quotes, the prompt is displayed in uppercase.
%USER
displays the session user name as the prompt.
%MODE
displays the operating mode of the session as the prompt.
%SERVER
displays the session host name and port number as the prompt.
%SCHEMA
displays the session schema as the prompt.
%DATASOURCE
displays the session data source as the prompt.
Considerations
• You must enter the command on one line. The command does not require an SQL terminator.
• Unlike SET SQLPROMPT, you can execute this command in other modes.
• To reset the default prompt, enter this command:
SET PROMPT
Examples
• This SET PROMPT command sets the SQL prompt to ENTER>:
SET PROMPT Command 127