Neoview Script Guide (R2.2)

within double quotes. To look for similar values, specify only part of the characters of
wild-card-pattern combined with these wild-card characters:
Use a percent sign to indicate zero or more characters
of any type. For example, %art% matches SMART,
ARTIFICIAL, and PARTICULAR but not smart or
Hearts. "%art%" matches smart and Hearts but not
SMART, ARTIFICIAL, or PARTICULAR.
%
Use an underscore to indicate any single character. For
example, boo_ matches BOOK and BOOT but not BOO or
BOOTS. "boo_" matches book and boot but not boo
or boots.
_
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.
• If you do not specify a wild-card pattern in a SHOW SCHEMAS command, Neoview Script
displays all the schemas that exist in the default catalog.
• If you specify a wild-card pattern in a SHOW SCHEMAS command, Neoview Script displays
only the schema names that match the wild-card pattern.
Examples
• This 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>
• 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 60).
SHOW SESSION Command
SHOW SESSION or SESSION displays attributes of the current Neoview Script session. You can
also use the ENV command to perform the same function.
128 Neoview Script Interface Commands