Filter
Top Products
Syntax
SHOW PARAM
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 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 that parameters that are set for the current session:
SQL>show param
lastname GREEN
dn 1500
sal 40000.00
• This command shows that when no parameters exist, the SHOW PARAM command displays
an error message:
SQL>show param
No parameters found.
For more information, see “Displaying the Parameters of the Session” (page 61).
SHOW PREPARED Command
The SHOW PREPARED command displays the prepared statements in the current Neoview
Script session. If a pattern is specified, all prepared statements matching the prepared statement
name pattern are displayed. By default, all prepared statements in the current session are
displayed.
Syntax
SHOW PREPARED [stmtNamePattern]
Considerations
In the Neoview Script interface, you must enter the command on one line. The SHOW PREPARED
command can be executed only in SQL mode.
SHOW PREPARED Command 119