ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-69
PROFILE Statements
QST_MODE_ON { Y | N }
specifies whether to log query status for each statement executed:
SQL_ACCESS_MODE { RO | RW }
specifies the default locking when the user does not explicitly state the access
intentions:
If you specify RO, any INSERT, UPDATE, or DELETE statements return errors.
SQL_CURSOR_MODE { RO | RW }
specifies the default used by the parser/translator to modify cursor definitions when
the user does not explicitly state access intentions:
SQL_DIALECT { TDM_CORE | TDM_TSQL }
specifies the SQL dialect that will be used by the client:
The client and server must use the same SQL dialect; otherwise, errors such as
“bad syntax” can occur.
SQL_MAX_STATEMENT_CACHE user-statement-cache-limit
specifies the maximum number of user statements that can be cached;
user-statement-cache-limit is an INT number that ranges from 1 through
32,767. Zero (0) indicates that the user statement caching mechanism is OFF.
SQL_TXN_ISOLATION { 0 | 1 | 2 | 3 }
is a numeric character that specifies the default transaction isolation level:
Y Log query status for each statement executed.
N Do not log query status for each statement executed.
RO Read-only access; INSERT, UPDATE, or DELETE statements return
errors
RW Read/write access
RO Read-only access
RW Read/write access
TDM_CORE CORE SQL
TDM_TSQL Transact-SQL
SQL_TXN_ISOLATION Value NonStop SQL/MP Access
0 SQL_TXN_READ_UNCOMMITTED BROWSE