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

SQL>set prompt Enter>
ENTER>
• This SET PROMPT command sets the CS prompt to #:
ENTER>mode cs
CS#set prompt #
#
• To reset the CS prompt to the default, enter this SET PROMPT command:
#set prompt
CS#
• To reset the SQL prompt to the default, enter this SET PROMPT command:
CS#mode sql
ENTER>set prompt
SQL>
• This command displays the session user name for the prompt:
SQL>set prompt %user>
dba1>
• This command displays the operating mode of the session for the prompt:
SQL>set prompt %mode:
SQL:
• This command displays the session host name and port number for the prompt:
SQL>set prompt %server>
neo0101.mylab.mycorp.net:18650>
• This command displays the session schema for the prompt:
SQL>set prompt "Schema %schema:"
Schema USR:
• This command displays the session data source for the prompt:
SQL>set prompt "%datasource SQL>"
TDM_Default_DataSource SQL>
• This command displays multiple session variables:
SQL>set prompt %USER@%SCHEMA>
super.super@USR>
SQL> set prompt %SERVER@DATASOURCE>
nci0101:23000@TDM_Default_DataSource>
SQL>set prompt ”%schema NCI> ”
NVSCHEMA NCI>
For more information, see “Customizing the Standard Prompt” (page 61).
128 NCI Commands