ODBC Server Reference Manual

Summary of System Installation Defaults
HP NonStop ODBC Server Reference Manual—429151-002
D-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_ERROR_sqlcode INT(2) This item is not available by
default; it is only present if added
using the ADD SCFG command. If
COLLECT_SQL_ERROR_INFO is
Y, then 1 indicates that NOS
should abend when sqlcode is
returned.
SQL_MAX_STATEMENT_
CACHE
INT (8) 0
SQL_TXN_ISOLATION CHAR (1) 1 indicates stable access.
SQL_UNSUPPORTED CHAR (1) E (indicates that any unsupported
syntactical token is reported as an
error and the statement fails)
SQL_WARNING_sqlcode INT(2) This item is not available by
default; it is only present if added
using the ADD SCFG command. If
COLLECT_SQL_ERROR_INFO is
Y, then 1 indicates that NOS
should abend when sqlcode is
returned.
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
Table D-1. System Default Values Installed in ZNSSCFG (page 4 of 5)
Column Name or Attribute
(Stored in the ITEM Column)
Table
Data Type
System Default (Stored
in the VALUE Column)