Neoview Script Guide (R2.2)

Examples
• This command displays the attributes of the current session:
SQL>show session
COLSEP ","
DATASOURCE TDM_Default_DataSource
HISTOPT ALL
IDLETIMEOUT 30 min(s)
LIST COUNT 0 [All Rows]
LOG OFF
LOOK AND FEEL NVS
MARKUP XML
MODE SQL
PROMPT SQL>
SCHEMA USR
SERVER neo0101.acme.com:18650
SQLTERMINATOR ;
TIME OFF
TIMING OFF
USER role.dba
• This command shows the effect of setting various session attributes:
SQL>session
COLSEP " "
DATASOURCE TDM_Default_DataSource
HISTOPT ALL
IDLETIMEOUT 30 min(s)
LIST COUNT 0 [All Rows]
LOG OFF
LOOK AND FEEL NVS
MARKUP RAW
MODE SQL
PROMPT SQL >
SCHEMA USR
SERVER neo0101.acme.com:18650
SQLTERMINATOR ;
TIME OFF
TIMING OFF
USER role.dba
SHOW SQLPROMPT Command
The SHOW SQLPROMPT command displays the value of the SQL prompt for the current Neoview
Script session.
Syntax
SHOW SQLPROMPT
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.
Example
This command shows that the SQL prompt for the current session is SQL>:
SQL>show sqlprompt
SQLPROMPT SQL>
130 Neoview Script Interface Commands