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

DBA001 DBA082 DBMGR
DBSCRIPT_SALES DEFINITION_SCHEMA_VERSION_1200 DEMOSCH
DEMOSCH1 DEMOSCH2 DEMO_SCH
DEV060525 DS_SCH D_SALES
HMGR HPNVS HPNVSSCH
HPNVS_SAMPLE HPNVS_SAMPLE INVENT
ODBC_INVENT ODBC_PERSNL ODBC_SALES
ODBC_SCHEMA ODBC_TEST PERSNL
PUBLIC_ACCESS_SCHEMA ROLEDBA ROLEMGR
ROLEUSER SALES SCH
SERVICES T4JDBC_SCHEMA TEST1
USR
SQL>
• This command shows the schemas in the default catalog that have “SALES” in their names:
SQL>show schemas %sales%
SCHEMA NAMES
------------------------------------------------------------------------
DBSCRIPT_SALES D_SALES ODBC_SALES
SALES
SQL>
For more information, see “Showing the Schemas” (page 65).
SHOW SESSION Command
SHOW SESSION or SESSION displays attributes of the current NCI session. You can also use
the ENV command to perform the same function.
Syntax
[SHOW] SESSION
Considerations
• You must enter the command on one line. The command does not require an SQL terminator.
• If the SET TIMING command is set to ON, the elapsed time information is displayed.
• SHOW SESSION or SESSION displays these attributes:
Current column separator, which is used to control how query results are
presented. For more information, see “SET COLSEP Command” (page 117).
COLSEP
Name of the data source that you entered when logging in to the database platform.
For more information, see “Logging In to the Database Platform” (page 53).
DATASOURCE
Current history options, which controls how the commands are added to the
history buffer. For more information, see “SET HISTOPT Command” (page 118).
HISTOPT
Current idle timeout value, which determines when the session expires after a
period of inactivity. By default, the idle timeout is 30 minutes. For more
information, see “Setting and Showing the Idle Timeout Value for the Session”
(page 63) and “SET IDLETIMEOUT Command” (page 119).
IDLETIMEOUT
Current list count, which is the maximum number of rows that can be returned
by SELECT statements. By default, the list count is all rows. For more information,
see “SET LIST_COUNT Command” (page 120).
LIST_COUNT
Current log file and the directory containing the log file. By default, logging during
a session is turned off. For more information, see “Logging Output” (page 73)
and “LOG Command” (page 104) or “SPOOL Command” (page 151).
LOG
Current look and feel of the NCI. This property affects the formatting of status
messages. For more information, see “Setting the Look and Feel of NCI” (page 42).
LOOK AND FEEL
142 NCI Commands