Component Integration Services includes changes to the delete command.
See also delete in the Reference Manual: Procedures
If Component Integration Services cannot forward the original query without alteration, it performs the delete using method 2.
If Component Integration Services cannot forward the original query without alteration, it performs the delete using method 2.
If Component Integration Services cannot forward the original query without alteration, you get an error because ASIQ does not support updatable cursors.
The syntax forwarded to servers of class direct_connect is dependent on the capabilities negotiation, which occurs when Component Integration Services first connects to the remote DirectConnect. Examples of negotiable capabilities include: subquery support, group by support, and built-in support.
Component Integration Services passes data values as parameters to either a cursor or a dynamic SQL statement. Language statements can also be used if the DirectConnect supports it. The parameters are in the datatype native to SAP ASE and must be converted by the DirectConnect into formats appropriate for the target DBMS.