SHOW

Use the SHOW command to display the current setting of a runtime parameter.

Syntax

Syntax for using the SHOW command:
SHOW <name>

Input

The SHOW command takes the following input:
Table 1. SHOW input
Input Description
<name> The name of a runtime parameter.

Output

The SHOW command has the following output:
Table 2. SHOW output
Output Description
SHOW VARIABLE The command was successful.

Privileges

You must be an administrator, or you must be able to connect to the database and schema.

Usage

The following provides sample usage.
  • To show the current setting of the DateStyle parameter: 
    MYDB.SCH1(USER)=> SHOW DateStyle;
   NOTICE:  DateStyle is ISO with US (NonEuropean) conventions