Kbase P97800: Can the SQL-92 "SET TRANSACTION ISOLATION LEVEL" statement be used in a Perl/DBI?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/2/2009 |
|
Status: Verified
GOAL:
SQL-92: Can the "SET TRANSACTION ISOLATION LEVEL" statement be used in Perl/DBI?
GOAL:
SQL-92: How does Progress support the "SET TRANSACTION ISOLATION LEVEL" statement?
GOAL:
SQL-92: Can the "SET TRANSACTION ISOLATION LEVEL" statement be used with ODBC client connections?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
No, Progress SQL-92 does not support the SET TRANSACTION ISOLATION LEVEL statement except in embedded SQL-92 to make the client-side SQL-92 application always aware of transaction characteristics.
In ODBC, the TRANSACTION ISOLATION LEVEL is a connection attribute. Use the ODBC SQLSetConnectAttr API function to set the TRANSACTION ISOLATION LEVEL as desired. Refer to your Perl/DBI language documentation for the exact syntax of how to invoke such an ODBC API call.