WARNING! DirectConnect for z/OS Option cannot correctly transfer varchar values containing empty strings (zero length non-null strings), in the bulk and template transfer process. Empty string varchar values are interpreted as NULL values.
Datatype conversion is handled differently for the two transfer types. After converting the incoming source database datatypes into appropriate Open Client and Open Server datatypes, the DB2 access service does one of the following:
For bulk copy transfer processing, the DB2 access service converts Open Client and Open Server datatypes into the actual datatypes of the target columns. If the source and target columns have incompatible datatypes, the transfer ends with an error.
For destination-template transfer processing, the DB2 access service uses the datatype qualifiers specified with the question marks in the template. When the questions marks do not have qualifiers, the DB2 access service uses the datatypes of the source to determine the default qualifiers.
When conversion fails, several properties, such as DefaultDate, NumConvertError, and CharConvertError, fill the field with the default value.
When you transfer data between two DB2 access services
(such as DB2 to Microsoft SQL Server, or Microsoft SQL Server to
DB2), Sybase recommends that you execute the transfer
from command from DB2 to guarantee native datatype mapping.
Also, the transfer from command is the only way
you can transfer text and image columns between DB2 access services.
