ODBC Server Installation and Management Manual

Summary of System Installation Defaults
HP NonStop ODBC Server Installation and Management Manual—429395-002
A-4
SO_KEEPALIVE INT (4) 0
SO_OOBINLINE INT (4) 0
SO_LINGER INT (4) 0
SO_REUSEADDR INT (4) 0
SP_READ CHAR (1) N
SP_WRITE CHAR (1) N
SQL_ACCESS_MODE CHAR (2) RW
SQL_CURSOR_MODE CHAR (2) RW (SQL_CURSOR_ DEFAULT
affects cursors not specified as
FOR READ ONLY or FOR
UPDATE. "RW" indicates the
cursor defaults to FOR UPDATE)
SQL_DIALECT CHAR (8) TDM_CORE
SQL_MAX_STATEMENT_
CACHE
INT (8) 0
SQL_TXN_ISOLATION CHAR (1) 1 (indicates stable access)
SQL_UNSUPPORTED CHAR (1) E (indicates any unsupported
syntactical token is reported as an
error and the statement fails)
START_TIME TIMESTAMP None
STMT_CACHED CHAR (1) None
STMT_NAME_CACHE CHAR (1) Y
STMT_ORIGIN CHAR (1) None
STMT_STATUS CHAR (1) None
STMT_TYPE CHAR (1) None
SWAPVOL CHAR (25) " " (no default is assigned)
TRA_ERROR CHAR (1) N
TRA_LEVEL VARCHAR (60) " " (no default is assigned)
TRA_MODE_ON CHAR (1) N
TRA_NAME VARCHAR (60) " " (no default is assigned)
Table A-1. System Default Values Installed in ZNSSCFG (page 4 of 4)
Column Name or Attribute
(Stored in the ITEM Column)
Table
Data Type
System Default (Stored
in the VALUE Column)