Sorry for my english.
I've php + Db2.(./configure --with-ibm-db2=/home/db2inst1/sqllib)

Now. For exaple, i'm trying to execute such script:

<?php function dbconnect($verbose) {
 $dbname = "SAMPLE";
 $username = "db2inst1";
 $password = "ibmdb2";
 // odbc_connect returns 0 if the connection attempt fails;
 // otherwise it returns a connection ID used by other ODBC functions
 $dbconn = odbc_connect($dbname, $username, $password);
 if (($verbose == TRUE) && ($dbconn == 0))
 {
 echo("Connection to database failed.");
 $sqlerror = odbc_errormsg($dbconn);
 echo($sqlerror);
 }
 else echo "connection successfull\n";
 $q="Select count(*) from SYSIBM.SYSTABLES";
 echo "preparing query";
 $rs=odbc_prepare($dbconn,$q);
 return($dbconn);
 }
 dbconnect(TRUE);
 ?>

And I'm getting next result:

db2inst1@redcell4 htdocs]$ php ./tdb.php
connection successfull
preparing query
Warning: SQL error: [IBM][CLI Driver][DB2] SQL0228N FOR UPDATE clause
specified for read-only cursor "SQLCUR4 ".  SQLSTATE=42620
, SQL state 42620 in SQLPrepare in /usr/local/apache/htdocs/tdb.php on line
20

[db2inst1@redcell4 htdocs]$

[db2inst1@redcell4 htdocs]$ db2 "? SQL0228N"

 SQL0228N FOR UPDATE clause specified for read-only cursor
          "<cursor-name>".

Explanation:  Cursor "<cursor-name>" is defined as INSENSITIVE
SCROLL, but the corresponding SELECT statement contains a FOR
UPDATE clause.

The statement cannot be processed.

User Response:  To define a read-only cursor, specify INSENSITIVE
on DECLARE CURSOR, but do not specify the FOR UPDATE clause as
part of the SELECT statement of the cursor.

sqlcode:   -228

sqlstate:  42620




I think that in function odbc_prepare cursor is created.

So I'm trying to add parameter SQL_CUR_USE_ODBC  to connect string. That is "$dbconn = odbc_connect($dbname, $username,
$password,SQL_CUR_USE_ODBC )".

Result is changed, but it is wrong result:

php ./tdb.php

Warning: SQL error: [IBM][CLI Driver] CLI0150E  Driver not capable.
SQLSTATE=S1C00, SQL state S1C00 in SQLSetConnectOption in
/usr/local/apache/htdocs/tdb.php on line 10
Connection to database failed.
Warning: odbc_errormsg(): supplied argument is not a valid ODBC-Link
resource in /usr/local/apache/htdocs/tdb.php on line 14
preparing query
Warning: odbc_prepare(): supplied argument is not a valid ODBC-Link resource
in /usr/local/apache/htdocs/tdb.php on line 20



[db2inst1@redcell4 htdocs]$ db2 "? CLI0150E"

 CLI0150E Driver not capable.

Explanation:  The operation is valid but not supported by either
the driver or the data source.

User Response:  Specify a valid operation.

[db2inst1@redcell4 htdocs]$

Where is problem in odbc_connect, odbc_prepare or in my mind? HELP PLEASE!