Gateway Initialization Parameters

Gateway initialization parameters can be divided into two groups. One is a set of generic initialization parameters that are common to all gateways and the other is a set of initialization parameters that are specific to individual gateways. The following generic initialization parameters are the only initialization parameters discussed in this document:

  • HS_BULK
  • HS_CALL_NAME
  • HS_COMMIT_POINT_STRENGTH
  • HS_DB_DOMAIN
  • HS_DB_INTERNAL_NAME
  • HS_DB_NAME
  • HS_DESCRIBE_CACHE_HWM
  • HS_FDS_ARRAY_EXEC
  • HS_FDS_CONNECT_INFO
  • HS_FDS_DEFAULT_SCHEMA_NAME
  • HS_FDS_SHAREABLE_NAME
  • HS_FDS_TRACE_LEVEL
  • HS_LANGUAGE
  • HS_LONG_PIECE_TRANSFER_SIZE
  • HS_NLS_DATE_FORMAT
  • HS_NLS_DATE_LANGUAGE
  • HS_NLS_NCHAR
  • HS_NLS_NUMERIC_CHARACTERS
  • HS_NLS_TIMESTAMP_FORMAT
  • HS_NLS_TIMESTAMP_TZ_FORMAT
  • HS_OPEN_CURSORS
  • HS_ROWID_CACHE_SIZE
  • HS_RPC_FETCH_REBLOCKING
  • HS_RPC_FETCH_SIZE
  • HS_TIME_ZONE

Do not use the PRIVATE keyword when setting any of these parameters. Using the PRIVATE keyword prevents the parameter from being uploaded to the server and can cause errors in SQL processing. None of these parameters needs to be set in the environment, so you do not need to use the SET keyword.

See Also:

Individual gateway documentation for the list of initialization parameters specific to a gateway