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 Enterprise default behavior. You can change the options for TDS connections at any time.

Prerequisites

There are no prerequisites for this task.

Task
  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