When a SQL statement such as a select, insert, delete, or update contains a built-in function, Component Integration Services has to determine whether or not the function can be forwarded to the remote server, or if it must be evaluated within the local server using remote data.
Functions are only sent to a remote server if the statement containing them can be handled by quickpass mode.
In the tables shown below, support for function by server class is indicated by a ‘Y’; ‘N’ indicates no support is provided, and ‘C’ indicates support for it is determined by capabilities of the underlying DBMS (often the case for DirectConnects).
