ASE has a strict model for processing language statements as RPC events:
It connects to the remote DriectConnect server and submits the RPC.
After it processes the results, it disconnects.
These quick connects and disconnects provide minimal network traffic.
When you log in to ASE, you must use a valid ECDA Option for ODBC target database user ID and password.
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 T-SQL dialect.
These rules apply for commitment control:
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.
