SHOW Statement

You are looking at an older version of the documentation. The latest version is found here.

The SHOW statement can be used to display a variety of information. It is not yet a language feature of the Data Virtuality Server and is handled only in the JDBC client.

Usage:

• SHOW - the inverse of SET, shows the property value for the given property, returns a result set with a single string column with a name matching the property key.
• SHOW PLAN - returns a resultset with a clob column PLAN_TEXT, an XML column PLAN_XML, and a clob column DEBUG_LOG with a row containing the values from the previously executed query. If SHOWPLAN is OFF or no plan is available, no rows are returned. If SHOWPLAN is not set to DEBUG, then DEBUG_LOG will return a null value.
• SHOW ANNOTATIONS - returns a resultset with string columns CATEGORY, PRIORITY, ANNOTATION, RESOLUTION and a row for each annotation on the previously executed query. If SHOWPLAN is OFF or no plan is available, no rows are returned.
• SHOW ALL  - returns a resultset with a NAME string column and a VALUE string column with a row entry for every property value. The SHOW statement is most commonly used to retrieve the query plan, see the plan debug example.