[PHP-DOC] cvs: phpdoc /en/reference/ibm_db2/functions db2-exec.xml db2-execute.xml
jsgoupilTue Oct 3 23:10:41 2006 UTC Modified files: /phpdoc/en/reference/ibm_db2/functions db2-exec.xml db2-execute.xml Log: fix typo (differnt) + fix WS + fix Example (closing ?> http://cvs.php.net/viewvc.cgi/phpdoc/en/reference/ibm_db2/functions/db2-exec.xml?r1=1.8&r2=1.9&diff_format=u Index: phpdoc/en/reference/ibm_db2/functions/db2-exec.xml diff -u phpdoc/en/reference/ibm_db2/functions/db2-exec.xml:1.8 phpdoc/en/reference/ibm_db2/functions/db2-exec.xml:1.9 --- phpdoc/en/reference/ibm_db2/functions/db2-exec.xml:1.8 Tue Oct 3 01:49:39 2006 +++ phpdoc/en/reference/ibm_db2/functions/db2-exec.xml Tue Oct 3 23:10:41 2006 @@ -1,5 +1,5 @@ - + @@ -187,10 +187,10 @@ Returning XML data as a SQL ResultSet -The following example demonstrates how to work with documents stored -in a XML column using the SAMPLE database. Using some pretty simple -SQL/XML, this example returns some of the nodes in a XML document in -a SQL ResultSet format that most users are familiar with. + The following example demonstrates how to work with documents stored + in a XML column using the SAMPLE database. Using some pretty simple + SQL/XML, this example returns some of the nodes in a XML document in + a SQL ResultSet format that most users are familiar with. &example.outputs; http://cvs.php.net/viewvc.cgi/phpdoc/en/reference/ibm_db2/functions/db2-execute.xml?r1=1.7&r2=1.8&diff_format=u Index: phpdoc/en/reference/ibm_db2/functions/db2-execute.xml diff -u phpdoc/en/reference/ibm_db2/functions/db2-execute.xml:1.7 phpdoc/en/reference/ibm_db2/functions/db2-execute.xml:1.8 --- phpdoc/en/reference/ibm_db2/functions/db2-execute.xml:1.7 Tue Oct 3 01:49:39 2006 +++ phpdoc/en/reference/ibm_db2/functions/db2-execute.xml Tue Oct 3 23:10:41 2006 @@ -1,5 +1,5 @@ - + @@ -138,10 +138,10 @@ Returning XML data as a SQL ResultSet -The following example demonstrates how to work with documents stored -in a XML column using the SAMPLE database. Using some pretty simple -SQL/XML, this example returns some of the nodes in a XML document in -a SQL ResultSet format that most users are familiar with. + The following example demonstrates how to work with documents stored + in a XML column using the SAMPLE database. Using some pretty simple + SQL/XML, this example returns some of the nodes in a XML document in + a SQL ResultSet format that most users are familiar with.
[PHP-DOC] cvs: phpdoc /en/reference/ibm_db2/functions db2-exec.xml db2-execute.xml
dbs Tue Oct 3 01:49:39 2006 UTC Modified files: /phpdoc/en/reference/ibm_db2/functions db2-exec.xml db2-execute.xml Log: Add SQL XML examples (patch from Owain Jones, IBM) http://cvs.php.net/viewvc.cgi/phpdoc/en/reference/ibm_db2/functions/db2-exec.xml?r1=1.7&r2=1.8&diff_format=u Index: phpdoc/en/reference/ibm_db2/functions/db2-exec.xml diff -u phpdoc/en/reference/ibm_db2/functions/db2-exec.xml:1.7 phpdoc/en/reference/ibm_db2/functions/db2-exec.xml:1.8 --- phpdoc/en/reference/ibm_db2/functions/db2-exec.xml:1.7 Mon Sep 19 14:31:25 2005 +++ phpdoc/en/reference/ibm_db2/functions/db2-exec.xml Tue Oct 3 01:49:39 2006 @@ -1,5 +1,5 @@ - + @@ -184,6 +184,180 @@ ]]> + +Returning XML data as a SQL ResultSet + +The following example demonstrates how to work with documents stored +in a XML column using the SAMPLE database. Using some pretty simple +SQL/XML, this example returns some of the nodes in a XML document in +a SQL ResultSet format that most users are familiar with. + + + + +&example.outputs; + + + + + +Performing a "JOIN" with XML data + +The following example works with documents stored in 2 differnt +XML columns in the SAMPLE database. It creates 2 temporary +tables from the XML documents from 2 different columns and +returns a SQL ResultSet with information regarding shipping +status for the customer. + + + + +&example.outputs; + + + + + +Returning SQL data as part of a larger XML document + +The following example works with a portion of the PRODUCT.DESCRIPTION +documents in the SAMPLE database. It creates a XML document containing +product description (XML data) and pricing info (SQL data). + + + + +&example.outputs; + + + + http://cvs.php.net/viewvc.cgi/phpdoc/en/reference/ibm_db2/functions/db2-execute.xml?r1=1.6&r2=1.7&diff_format=u Index: phpdoc/en/reference/ibm_db2/functions/db2-execute.xml diff -u phpdoc/en/reference/ibm_db2/functions/db2-execute.xml:1.6 phpdoc/en/reference/ibm_db2/functions/db2-execute.xml:1.7 --- phpdoc/en/reference/ibm_db2/functions/db2-execute.xml:1.6 Tue Jul 12 17:39:24 2005 +++ phpdoc/en/reference/ibm_db2/functions/db2-execute.xml Tue Oct 3 01:49:39 2006 @@ -1,5 +1,5 @@ - + @@ -135,8 +135,202 @@ ]]> + +Returning XML data as a SQL ResultSet + +The following example demonstrates how to work with documents stored +in a XML column using the SAMPLE database. Using some pretty simple +SQL/XML, this example returns some of the nodes in a XML document in +a SQL ResultSet format that most users are familiar with. + + + + +&example.outputs; + + + + + +Performing a "JOIN" with XML data + +The following example works with documents stored in 2 differnt +XML columns in the SAMPLE database. It creates 2 temporary +tables from the XML documents from 2 different columns and +returns a SQL ResultSet with information regarding shipping +status for the customer. + + + + +&example.outputs; + + + + + +Returning SQL data as part of a larger XML document + +The following example works with a portion of the PRODUCT.DESCRIPTION +documents in the SAMPLE database. It creates a XML document containing +product description (XML data) and pricing info (SQL data). + + + + +&example.outputs; + + + +