Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » Replication » SQL Anywhere as an Open Server » Characteristics of Sybase Open Client and jConnect connections

 

Changing the option settings for TDS connections

When SQL Anywhere 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.

Prérequis

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.

Résultat

Future connections use the procedure. You can configure the procedure differently for different user IDs.

Exemple

This procedure example changes only the quoted_identifier option from the default setting.

CREATE PROCEDURE my_startup_procedure()
BEGIN
  IF CONNECTION_PROPERTY('CommProtocol')='TDS' THEN
    SET TEMPORARY OPTION quoted_identifier='Off';
  END IF
END;

Run the following command to set the login_procedure option to the name of the new procedure:

SET OPTION login_procedure= 'DBA.my_startup_procedure';

 See also