note 64386 added to function.db2-exec
| From: | mitrofun at mail dot ru | Date: | Thu, 13 Apr 2006 10:15:17 +0000 |
| Subject: | note 64386 added to function.db2-exec | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-107963@lists.php.net to get a copy of this message | ||
Hi, All.
Im traing to get result set from DB2/390 V7 subsytem.
My web server have next configuration :
Windows 2000 + DB2 Connect 7.2.8 + Apache 1.3.14 + PHP 4.4.1
аnd latest version of extension php_ibm_db2.dll
I have next simple script :
<?php
include "connection.inc";
$conn = db2_connect($database, $user, $password);
$sql = 'SELECT regioncup_id, name FROM dbo0.nvregioncup';
$res = db2_exec($conn,$sql);
while (db2_fetch_row($res)) {
$reg_id = db2_result($res, 0);
$name = db2_result($res, 1);
echo $reg_id."--------".$name;
}
?>
But this script fail with error :
Warning: db2_exec(): Statement Execute Failed in d:\\phptest\\ibm_db2\\mf_st_proc.php on line 8
----
Server IP: 66.163.161.117
Probable Submitter: 62.76.45.247 (proxied: 10.64.10.197)
----
X-Spam-Status: No, hits=3.1 required=5.0 tests=DATE_MISSING,FROM_NO_LOWER
autolearn=no version=2.64
----
Manual Page -- http://www.php.net/manual/en/function.db2-exec.php
Edit -- http://master.php.net/note/edit/64386
Del: integrated -- http://master.php.net/note/delete/64386/integrated
Del: useless -- http://master.php.net/note/delete/64386/useless
Del: bad code -- http://master.php.net/note/delete/64386/bad+code
Del: spam -- http://master.php.net/note/delete/64386/spam
Del: non-english -- http://master.php.net/note/delete/64386/non-english
Del: in docs -- http://master.php.net/note/delete/64386/in+docs
Del: other reasons-- http://master.php.net/note/delete/64386
Reject -- http://master.php.net/note/reject/64386
Search -- http://master.php.net/manage/user-notes.php