Unanswered: Using ODBC API in php to connect to DB2
I am using ODBC api in PHP to connect to DB2 database. It is working fine but slow and lots and lots of locking. I came to know that all the transactions in DB2 are read/write and i want to change this setting.
Thanks for writing these articles which will really help many people in understanding how to connect to db2 from php.
If you read my post, i was able to connect/extract data from DB2 using PHP but the real problem was the way DB2 locks its objects. I have tried using
" for ready only" or " with read only" or " with UR"
in my sql queries but there was no good result.
When i use some other database i.e. firebird, it provides me the provision of metioning what kind of transaction I am doing using ODBC connection but with DB2 i can't do that. If there is a way please inform me.
If you are interested you can read my post about the same here