|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2007-05-20 21:53 UTC] opendev at us dot ibm dot com
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Wed Nov 05 04:00:01 2025 UTC |
Description: ------------ With IBM DB2 9.1 you can use XQuery for XML data. This code produces an error, but works in the DB2 Control Center: xquery db2-fn:xmlcolumn('TALKS.TALKS'); Sorry for the German error messages... Reproduce code: --------------- <?php $stmt = $db->prepare("xquery db2-fn:xmlcolumn('TALKS.TALKS')"); if ($stmt->execute()) { foreach ($stmt->fetch() as $data) { var_dump($data); } } else { print_r($stmt->errorInfo()); } Expected result: ---------------- After XML serialization: <talks> <talk id="1"> <presenter> Thorsten Rinne </presenter> <title> IBM DB2 mit PHP 5.2 und AJAX </title> <date> 2007-05-23 </date> </talk> </talks> Actual result: -------------- Array ( [0] => 10505 [1] => -16002 [2] => [IBM][CLI Driver][DB2/NT] SQL16002N In einem XQuery-Ausdruck folgt ein unerwartetes Token "?" auf "db2-fn". Zu den m?glichen Token geh?ren: "". Fehler QName=err:XPST0003. SQLSTATE=10505 (SQLExecute[-16002] at ext\pdo_odbc\odbc_stmt.c:133) [3] => 10505 )