Show TOC

rs_session_settingLocate this document in the navigation structure

Sets SAP IQ parameters and database options for the duration of the connection to the SAP IQ replicate database.

Examples
Example 1
Create the rs_session_setting function string for the my_iq_fclass function-string class, and include the SAP IQ parameters you want to set such as, the LOAD_MEMORY_MB, MINIMIZE_STORAGE, and JOIN_PREFERENCE SAP IQ database options:
create function string rs_session_setting
for my_iq_fclass
output language
'set temporary option Load_Memory_MB=''200''
set temporary option Minimize_Storage=''on''
set temporary option join_preference=5'
go
Usage
  • The values for the SAP IQ database options are set with the TEMPORARY keyword and therefore, apply only to the current SAP IQ connection. The values revert to the default values or the values set earlier without the TEMPORARY keyword, when the connection to the SAP IQ database is restarted. See SAP IQ > Reference: Statements and Options > Database Options > Introduction to Database Options > Setting Options.
  • rs_session_setting has function-string class scope.

  • Replication Server creates an initial rs_session_setting function string for the system-provided function-string classes during installation.
  • Create or customize an rs_session_setting function string at the Replication Server that is the primary site for the class.

  • The default generated function string for the rs_session_setting function for the:
    • rs_sqlserver_function_class and rs_default_function_class classes is an empty string
    • rs_iq_function_class class is:
      {set temporary option Load_Memory_MB=''200'' 
      set temporary option Minimize_Storage=''on''
      set temporary option join_preference=5}
  • The LOAD_MEMORY_MB database option is deprecated in Sybase 15.2 and later. See Sybase IQ 15.2 > New Features Summary > Behavior Changes > Database Option Changes.