DirectConnect issues

The following table lists outstanding issues that apply to DirectConnect products. Each issue identifies specific hardware or operating system information, a workaround (if available), and the QTS assigned to it.

Known issues for specific DirectConnect products are described in the table and the following sections.

Table 6: Known issues for DirectConnect products

Product

Platform

Description

Workaround

QTS #

All DirectConnects except DirectConnect for Oracle

All

Express transfer does not support the transfer of char datatypes to and from decimal datatypes.

Use the SQL CAST function to convert query datatypes from char to decimal datatypes in the transfer query statement.

None.

All

Express transfer does not support the transfer of text datatypes to and from char datatypes.

Use the SQL CAST function to convert query datatypes from text to char datatypes in the transfer query statement.

None.

Linux

When executing a bulk transfer on the Linux platform, DirectConnect may report LONGCHAR errors and abort the transfer. When transferring character data through a Linux-based DirectConnect ECDA to an ASE 15.0, the transfer of char columns may fail. This results from a charset incompatibility between the Linux platform-based DirectConnect and ASE. The transfer may be attempting to move UTF-8 double-byte data into an ASE configured for single-byte characters like iso_1 or cp_850.

Correct his problem by setting the Linux $LANG variable to the desired name value found in the locales.dat file.

None.

DirectConnect for DB2 UDB only

All

CLOB data is limited to 32K. BLOB datatype is not supported.

Use DirectConnect for z/OS.

None.

All

Specifying the host name as the IP Address causes a failure on some Sun Solaris systems.

You must specify the IP Number as the IP Address.

None.

DirectConnect for Microsoft SQL Server

All

An update of read-only cursors fails to return errors against Microsoft SQL Server 2005.

None.

425343

All

ASE/CIS is not correctly mapped to the correct datatype, resulting in insert failures.

None.

275506