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, the following 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 interfaces file for DirectConnect installations on UNIX or in the sql.ini file for DirectConnect installations on Windows.
WARNING! DirectConnect cannot correctly transfer varchar values containing empty strings (zero length non-null strings), in the bulk transfer process. Empty string varchar values are interpreted as NULL values.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
