Show Table of Contents
3.10. The SHOW Statement
The SHOW statement can be used to see a variety of information. The SHOW statement is not yet a language feature of JBoss Data Virtualization and is handled only in the JDBC client.
- SHOW PLAN
SHOW PLANreturns 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
SHOW ANNOTATIONSreturns 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 <property>
SHOW <property>is the inverse of SET and shows the property value for the property supplied. It returns a resultset with a single string column with a name matching the property key.- SHOW ALL
SHOW ALLreturns a resultset with a NAME string column and a VALUE string column with a row entry for every property value.
Where did the comment section go?
Red Hat's documentation publication system recently went through an upgrade to enable speedier, more mobile-friendly content. We decided to re-evaluate our commenting platform to ensure that it meets your expectations and serves as an optimal feedback mechanism. During this redesign, we invite your input on providing feedback on Red Hat documentation via the discussion platform.