note 64386 rejected from function.db2-exec by bjori
| From: | bjori@php.net | Date: | Thu, 13 Apr 2006 11:21:37 +0000 |
| Subject: | note 64386 rejected from function.db2-exec by bjori | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-107977@lists.php.net to get a copy of this message | ||
Note Submitter: mitrofun at mail dot ru
----
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