insert commands using the values keyword are fully supported.
insert commands using a select command are supported for all datatypes except text and image. text and image columns are only supported when they contain null values.
If all insert and select tables reside on the same remote server, the entire statement is forwarded to the remote server for execution. This is referred to as quickpass mode. Quickpass mode is not used if select does not conform to all the quickpass rules for a select command.
If the select tables reside on one remote server, and the insert table resides on a different server, Component Integration Services selects each row from the source tables, and inserts the row into the target table.
You cannot insert into a computed column.
Handling of the insert statement is the same as for ASEnterprise.
Handling of the insert statement is the same as for ASEnterprise.
insert commands using the values keyword are fully supported.
insert commands using a select command are fully supported, but the table must have a unique index if the table has text or image columns. When using insert with a select command, the entire command is sent to the remote server if:
All tables referenced in the command reside on the remote server.
The capability’s response from the DirectConnect indicates that insert-select commands are supported.
If you use the TopN feature, you must have an order by clause.
If both conditions are not met, Component Integration Services selects each row from the source tables, and inserts the row into the target table.
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 Adaptive Server and must be converted by the DirectConnect into formats appropriate for the target DBMS.
insert in the Reference Manual
