KDB connection attributes

>Database Constants

Database connection attribute constants

This is an enumeration of the constants defining the connection attributes used by KI_CONNECT_GET_ATTR and KI_CONNECT_SET_ATTR routines.

DEF ENUM enumeration name KDB_CONNECT_ATTR_ENUM

Enumeration ValueValueDescription
_KDB_CONN_ATTR_CACHESIZE1Oracle statement cache size, 0 for no caching
_KDB_CONN_ATTR_PARTITION2enable/disable Oracle partitions
_KDB_CONN_ATTR_XA3TRUE to enable XA transactions
_KDB_CONN_ATTR_LOCKS4TRUE to enable mandatory lock checking
_KDB_CONN_ATTR_VIEWS5TRUE to enable view emulation on KDB and cache files
_KDB_CONN_ATTR_DEADLOCK6if non zero then fail every nth READ_HOLD
_KDB_CONN_ATTR_TRANS_STATUS7inner most WHILE TRANS status
_KDB_CONN_ATTR_ALLOWINTX8allow otherwise restricted operation in a TX
_KDB_CONN_ATTR_CLIENT_ID9Oracle client id
_KDB_CONN_ATTR_CLIENT_INFO10Oracle client info
_KDB_CONN_ATTR_RESOURCE_GROUP11Oracle RESOURCE CONSUMER GROUP
_KDB_CONN_ATTR_SET_ENV12TRUE to set environment variables from kconf.xml
_KDB_CONN_ATTR_COMMIT_WRITE13Oracle commit_write initialization parameter
_KDB_CONN_ATTR_CURSORCACHE14Oracle number of plans to cache
_KDB_CONN_ATTR_AUDIT_NAME15LOGNAME used for stamping KDBUSER column
_KDB_CONN_ATTR_RO_ROLE16Name of a role to get RO access to Oracle tables
_KDB_CONN_ATTR_DEFER_OPEN17Set to defer table open until accessed
_KDB_CONN_ATTR_FAILOVER18Set to fail server every so many round trips
_KDB_CONN_ATTR_IN_DP_LOAD19Set if in Oracle Direct Path load, - KI_WRITE_RAW
_KDB_CONN_ATTR_DP_LOAD_BUFSZ20Oracle Direct Path load, - KI_WRITE_RAW buffer size
_KDB_CONN_ATTR_PREFETCH21Default number of rows to prefetch
_KDB_CONN_ATTR_RETRY_MAX22Default max retries of a deadlocked TX
_KDB_CONN_ATTR_RETRY_DELAY23Default initial delay before restarting a TX in ms
_KDB_CONN_ATTR_RETRY_COUNT24 Number of retries so far in a deadlocked TX
_KDB_CONN_ATTR_KEY_PADDING25How to handle HEX(FF) in a key
_KDB_CONN_ATTR_START_WINDOW26Window size for open starts
_KDB_CONN_ATTR_OPT_TRANS27Connection should do optimistic transactions
_KDB_CONN_ATTR_CACHE_DIR28Directory for cache tables
_KDB_CONN_ATTR_CACHE_ROWS29Maximum number of rows in cache tables
_KDB_CONN_ATTR_FIX_MINUS30Iff TRUE then map - to $ in tablenames
_KDB_CONN_ATTR_UPDATE_TX_MAX31The number of updates and deletes to force a commit
_KDB_CONN_ATTR_UPDATE_COUNT32Count of updates and deletes in this transaction
_KDB_CONN_ATTR_NO_COMMIT_ON_BREAK33Iff TRUE then optimistic transactions will not be committed on entering the workbench.
_KDB_CONN_ATTR_READ_ONLY34Database opened read-only
_KDB_CONN_ATTR_START_WINDOW_THRESHOLD35Number of windows after which we double the window size.
_KDB_CONN_ATTR_START_WINDOW_MAX36Maximum number of rows in an adaptive window
_KDB_CONN_ATTR_TABLESPACE_PREFIX37Mangle tablespace names with prefix
_KDB_CONN_ATTR_RECYCLEBIN38Toggle Oracle recycle bin on or off
_KDB_CONN_ATTR_RELOCK39SQL databases. Enable the session to relock a long term lock it already holds.
_KDB_CONN_ATTR_RELOCKTRANS40SQL databases. Enable the session to take a transactional lock on a row where is already holds a long term lock.
_KDB_CONN_ATTR_CATALOG_CACHE41Turn on catalog caching.
_KDB_CONN_ATTR_CHECKUTF842SQL databases. Check on INSERT for truncated UTF8 and replace with blanks.
_KDB_CONN_ATTR_NOEXPANDHINT43Oracle database. Add NO_EXPAND hint to SQL generated by a KI_START_BETWEEN.
_KDB_CONN_ATTR_WSMETHOD44Selects method to use to generate Word Search Indexes on Oracle
_KDB_CONN_ATTR_TABLECOMPRESSION45Oracle databases. Enable table and LOB compression.
_KDB_CONN_ATTR_COMPANYPARTITION46SQL databases. Enable automatic partitioning by company id.
_KDB_CONN_ATTR_AUTO_CATALOG_UPGRADE47SQL databases. Enable automatic upgrade of K$CATALOG.
_KDB_CONN_ATTR_VARCHAR_NULL_FILTER48SQL databases. When enabled, KCML will replace NULL values in inserts/updates to NOT NULL VARCHAR columns with single spaces.
_KDB_CONN_ATTR_FAILOVER_ERRORS49List of Oracle codes that may be treated as indicating the database server has failed and failover should be actioned.
_KDB_CONN_ATTR_CREATE_PRIMARY_KEYS50Oracle databases. When enabled, CREATE UNIQUE INDEX with path 1 will set the relevant column(s) as a primary key for the table.
_KDB_CONN_ATTR_CATALOG_CACHE_LIFETIME51How long the client should cache catalog entries for.
_KDB_CONN_ATTR_TYPE_CONVERSIONS52Specifies how results for this connection should be converted from database driver types to KCML types
_KDB_CONN_ATTR_AMEND_ORACLE_ROWIDS53Oracle databases. When enabled, ROWIDs will have the high bits of the file number segment zeroed out.
_KDB_CONN_ATTR_MAX_CURSOR_CACHE54Maximum number of cursors KCML will cache per connection.
_KDB_CONN_ATTR_MAX_DEF_QUERY_PARAMS55Maximum number of parameters that can be bound to a DefQuery
_KDB_CONN_ATTR_ADC_PORT56Local port that the ADC daemon inspects.
_KDB_CONN_ATTR_SHORT_ROWS57Suppress errors introduced in KCML 07.28 where the passed row buffer is shorter than the table row length.

Back to the list of Enumerations and Constants