(ESD #2) Sybase Open Client and Open Server 15.0 and the later releases of Sybase Open Client and Open Server 12.5.1 support several new datatypes: CS_BIGINT, CS_UBIGINT (unsigned bigint), CS_USMALLINT (unsigned smallint), CS_UINT (unsigned integer), CS_DATE, and CS_TIME. The ECDA Option for Oracle, the ECDA option for DB2 UDB, and the ECDA option for Microsoft SQL Server now support these datatypes between the client and target databases.
The ECDA options for Microsoft SQL Server and DB2 UDB support these express transfer options between:
BigInt and Numeric – allows transfer of data between the datatype columns by configuring the property BigIntResults to a value Legacy.
BigInt and BigInt – allows transfer of data between the datatype columns. The transfer does not require any changes to be done to the database configuration property sets.
Numeric and Numeric – allows transfer of data between the datatype columns.
Time and Time – allows transfer of data from DB2 UDB TIME (source) to ASE TIME (target) columns when the precision value of the target column is greater than the precision of the source column. If the precision value of the source column is greater than that of the target column, express transfer fails. Transfer from ASE TIME column to DB2 UDB TIME column is not supported by express transfer. Transfer bulk supports this transfer. Since DB2 UDB Time column does not support milliseconds, transfer bulk truncates the milliseconds during the conversion from ASE to DB2 UDB time value.
Time and Char – allows transfer from Time (source) to Char (target) columns only when target column has either equal or greater precision than the source column. Target column with smaller precision generates an error. For express transfer between Microsoft SQL Server Char column to DB2 UDB Time column requires IBM AS400 ODBC driver support. The Data Direct drivers generate an invalid data descriptor error. Alternatively, you can use transfer bulk for transferring data.
Unsigned (BigInt,Smallint, and Int) and Numeric – allows transfer of data between the datatype columns.
Express transfer does not support data transfer between an Unsigned (BigInt,Smallint, and Int) datatype column and a Char datatype column.
The express transfer option, which initiates a direct transfer of data between two databases from the client application, has these exceptions:
ASE DATE and TIME columns to DB2 UDB TIMESTAMP column are not supported.
ASE TIME column to DB2 UDB TIME column is not supported.
DB2 UDB TIME column does not accept values in fractional seconds. Therefore, all character values must be in the HH.MM.SS format.
DB2 UDB TIME column to ASE TIME column;
the value 24.00.00 is not supported.
However, you can use the bulk copy transfer option that supports these exceptions.
