Datatypes are incompatible when source and target table datatypes cannot be mapped to one another. For example, binary to datetime transfers are not allowed.
In bulk copy transfers, before the DB2 access service moves any data from the source database to the target database, the DB2 access service compares datatypes in the source to datatypes in the target.
In destination-template transfers, the DB2 access service compares the source table datatypes to the qualifiers set in the destination-template statement.
For bulk copy and destination-template transfer types, if any columns have incompatible datatypes, the DB2 access service cancels the transfer, without attempting to transfer any rows.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
