Sorry for my english. :-)
Unexpected problem! With db2 v6.1 this problem was not marked out. Execution of SQL statment "Select * from SYSIBM.SYSTABLES" generates next error:
<b>Warning</b>: SQL error: [IBM][CLI Driver][DB2] SQL0904N Unsuccessful
execution caused by an una
vailable resource. Reason code: "UPDATABLE WORKFILE", type of resource:
"100", and resource name: "
TEMP DATABASE ". SQLSTATE=57011
, SQL state 57011 in SQLExecute in <b>tstdb2.php</b> on line <b>35</b><br />
</HTML>
Execution of SQL statment "Select count(*) from SYSIBM.SYSTABLES" generates next error:
<b>Warning</b>: SQL error: [IBM][CLI Driver][DB2] SQL0228N FOR UPDATE
clause specified for read-onl
y cursor "SQLCUR4 ". SQLSTATE=42620
, SQL state 42620 in SQLPrepare in <b>tstdb2.php</b> on line <b>33</b><br />
In Windows system this problem has been solved by adding additional paaram to connect string :
odbc_connect($dsn,$uid,$pwd,SQL_CUR_USE_ODBC );
but on Linux it generates:
Warning: SQL error: [IBM][CLI Driver] CLI0150E Driver not capable.
SQLSTATE=S1C00, SQL state S1C00 in SQLSetConnectOption in
/usr/local/apache/htdocs/tstdb2.php on line 23
What's wron in php?
