Changing the option settings for TDS connections

When SAP Sybase IQ is serving applications over TDS, it automatically sets relevant database options to values compatible with Adaptive Server default behavior. You can change the options for TDS connections at any time.

  1. Create a procedure that sets the database options you want.
  2. Set the login_procedure option to the name of the new procedure.
Future connections use the procedure. You can configure the procedure differently for different user IDs.
Parent topic: Characteristics of Sybase Open Client and jConnect connections