Author: shawkins Date: 2009-09-25 16:29:56 -0400 (Fri, 25 Sep 2009) New Revision: 1482 Modified: trunk/documentation/reference/src/main/docbook/en-US/content/federated_planning.xml Log: updating programlisting of getting the query plan Modified: trunk/documentation/reference/src/main/docbook/en-US/content/federated_planning.xml =================================================================== --- trunk/documentation/reference/src/main/docbook/en-US/content/federated_planning.xml 2009-09-24 19:06:34 UTC (rev 1481) +++ trunk/documentation/reference/src/main/docbook/en-US/content/federated_planning.xml 2009-09-25 20:29:56 UTC (rev 1482) @@ -405,8 +405,17 @@ </para> <example> <title>Retrieving a Query Plan</title> - <programlisting>ResultSet rs = statement.executeQuery("select ..."); -com.metamatrix.jdbc.api.Statement mmstatement = (com.metamatrix.jdbc.api.Statement)statement; + <programlisting>com.metamatrix.jdbc.api.Statement mmstatement = (com.metamatrix.jdbc.api.Statement)statement; +String sql = "select ..."; + +mmstatement.setExecutionProperty(ExecutionProperties.PROP_SQL_OPTIONS, ExecutionProperties.SQL_OPTION_SHOWPLAN); +//or +//sql += " OPTION SHOWPLAN"; +//or +//sql += " OPTION PLANONLY"; + +ResultSet rs = statement.executeQuery(sql); + PlanNode queryPlan = mmstatement.getPlanDescription(); System.out.println(XMLOutputVisitor.convertToXML(queryPlan);</programlisting> </example>