ODBC Server Reference Manual

HP NonStop ODBC Server Mapping Tables
HP NonStop ODBC Server Reference Manual—429151-002
8-25
ZNSPROF (For Profile Values)
SQL_ACCESS_MODE
––
CHAR (2) Default mode in the current
session:
RW Read-write
RO Read-only
SQL_CURSOR_MODE
––
CHAR (2) SQL cursor mode. Forces “FOR
UPDATE” on cursor specifica-
tions that do not explicitly indi-
cate BROWSE:
RO Cursor defaults to
FOR READ ONLY
RW Cursor defaults to
FOR UPDATE
SQL_DIALECT
––
CHAR (8) Dialect affecting the NonStop
ODBC Server parser. Is either
TDM_CORE or TDM_TSQL.
SQL_MAX_
STATEMENT_CACHE
––
INT (2) Upper limit on the number of
SQL statements saved in the
NonStop ODBC Server cache.
SQL_TXN_ISOLATION
––
CHAR (1) Initial transaction isolation level.
SQL_UNSUPPORTED
––
CHAR (1) Return message level for syntax
errors and warnings:
E Report as error
W Report as warning
I Ignore
OBJ_NAME_CACHE
––
CHAR (1) Object name cache behavior.
STMT_CACHE_LEVEL
––
INT (4) Reserved.
CON_MODE_ON
––
CHAR (1) Flag indicating whether
CONTROL statements apply to
the session.
Table 8-12. Description of ZNSPROF (page3of4)
Column Name
Primary Key Unique Index
Data Type Description
x Indicates the column is part of the primary key or is a unique index
– Indicates the column is not part of the primary key or is not a unique index