ASE has a strict model for processing language statements as RPC events: It connects to the remote server and submits the RPC, and, after the results process, it disconnects. These quick connect and disconnect operations are a basic part of the ASE RPC design to provide minimal network traffic.
The user ID and password you use to sign on to ASE must be a valid target database user ID and password.
All SQL transformation rules apply:
If the DB2 access service is configured for passthrough mode, the SQL within the double quotes must comply with target SQL syntax.
If the DB2 access service is configured for sybase mode, the SQL must be in Sybase T-SQL dialect.
Consider the following:
If the DB2 access service is configured for long transactions, the SQL submitted must not be sensitive to a commit. In other words, 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 DB2 access service is configured for short transactions, the SQL submitted is bound by short transactions, which supply a commit by default.