Rules for Using Language Statements as RPCs

Process the language statement as RPCs.

Adaptive Server has a strict model for processing language statements as RPC events:

  1. It connects to the remote DirectConnect server and submits the RPC.

  2. After it processes the results, it disconnects.

These quick connects and disconnects provide minimal network traffic.

Validation

When you log in to Adaptive Server, you must use a valid ECDA Option for ODBC target database user ID and password.

Transformation Mode and Syntax

All SQL transformation rules apply, including:

  • If the DirectConnect server is configured for passthrough mode, the SQL within the double quotes must comply with the target SQL syntax.

  • If the DirectConnect server is configured for sybase mode, the SQL must be in Sybase Transact-SQL dialect.

Commitment Control Rules

  • If the access service is configured for long transactions, the SQL submitted must not be sensitive to a commit. For example, if the SQL is an insert statement that does not batch a commit into the statement, the insert rolls back using long transaction rules.

  • If the access service is configured for short transactions, the SQL submitted is bound by short transactions that supply a commit by default.

Parent topic: RPC Feature