(ESD #2) Sybase Open Client and Open Server™ 15.0 and the later versions 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
CS_TIME
The ECDA Option for Oracle and the ECDA Option for ODBC also support these datatypes between the client and target databases.
The ECDA Option for ODBC supports 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 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 Adaptive Server 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, but bulk copy transfer supports this transfer. Since DB2 UDB Time column does not support milliseconds, bulk copy transfer 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. Data Direct drivers generate an invalid data descriptor error. Alternatively, you can use bulk copy transfer 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, which supports these exceptions.
