Kbase P90001: ODBC/SQL-92: How to change transaction isolation level from PHP?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
ODBC/SQL-92: How to change transaction isolation level from PHP?
FACT(s) (Environment):
Progress 9.x
FIX:
You can change transaction isolatation level from PHP
code by using the following statement:
odbc_setoption (<connection>, <function>, <option>, <value>)
Please see PHP documentation for more detailed information on this statement
(e.g. www.phpbuilder.com/manual/function.odbc-setoption.php).
You can change the transaction isolation level (e.g. to
"read_uncommitted") according to the following example:
odbc_setoption ($conn, 1, 108, 1)
Where:
Connection: $conn for your connection
Function : 1 for SqlSetConnectOption
Option : SQL_TXN_ISOLATION=108
Parameters:
SQL_TXN_READ_UNCOMMITTED=1
SQL_TXN_READ_COMMITTED=2
SQL_TXN_REPEATABLE_READ=4
SQL_TXN_SERIALIZABLE=8
Your application can call "SQLGetInfo" to get the full list of options
supported by Progress ODBC Driver.