MX Release 3.1 (H06.23+, J06.12+)

ManualsBrandsHP ManualsServerHP Integrity NonStop H-Series

101

102

103

104

105

106

107

108

109

110

• If you specify a wildcard pattern in a show schemas command, RMXCI displays only the

schema names that match the wild-card pattern.

• If the set timing command is set to on, the elapsed time information appears.

Examples

• The following command shows all the schemas that exist in the default catalog of the current

session:

SQL>show schemas

SCHEMA NAMES

------------------------------------------------------------------------

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>

• The following 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 38).

SHOW SESSION command

The show session or session command displays attributes of the current RMXCI session. You

can also use the env command to perform the same function.

Syntax

[SHOW] SESSION

Considerations

• You must enter the command in one line.

• If the set timing command is set to on, the elapsed time information appears.

• The 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 84).

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 23).

DATASOURCE

Current history options, which controls how the commands are added to the history

buffer. For more information, see “SET HISTOPT command” (page 86).

HISTOPT

SHOW SESSION command 109