During a destination-template transfer, the access service inserts the data values it retrieves with the sourceselectstatement from the source database into the destination-template SQL clause. This clause contains one question mark for each column in the result set of the sourceselectstatement.
Each value from the result set is substituted for the corresponding question mark in the template on a row-by-row basis. The access service executes the resulting statement against the target database.When you use the destination-template transfer statement, these restrictions apply:
The transfer statement must be the only statement in a request.
The table into which you want to transfer data (the target) must already exist. The transfer statement does not create new tables in the transfer target.
The structure of the target table must match the structure of the source table.
For any transfer to work, the ConnectionSpec to the secondary connection must be recorded in the sql.ini file for Windows or in the interfaces file for UNIX.
WARNING! The DirectConnect server cannot correctly transfer varchar values containing empty strings (zero length non-null strings) in the destination-template transfer process. Empty string varchar values are interpreted as NULL values.
