OpenAccess SDK 5.6 (July 2007)

  • New Schema Storage Manager - Static schema data and view definitions are now stored in an optimized text file format and no longer use dBase format. This results in faster operations and uniform support for schema related features across all 32-bit and 64-bit platforms. Previously views were not supported on 64-bit platforms.
  • Compatibility with DataDirect ODBC Driver Manager - The OpenAccess ODBC Driver is now compatible with the DataDirect ODBC driver manager on UNIX when the driver is run in ANSI mode.
  • Enhanced data type support - Support BIT and TINYINT data types.
  • DataDirect Branding - The components and end user license agreements now bear the DataDirect Technologies company name and the DataDirect OpenAccess product name.

OPR#3379

Schema search object should filter '%' search pattern when it is used to read all tables. Previously the SCHEMA call would be required to handle this pattern and return all objects.

OPR#3430

Allow PWD to be 512 characters. Previously the limit was 256 characters.

OPR#3448

Support system views - validation should use default owner name as "SYSTEM"

OPR#3458

Improve join ordering to support Star join query

OPR#3466

Use CSV file format for Schema Management instead of Dbase format

OPR#3408

DQP is not correctly handling conditions on translated date columns and scalar functions that return date values

OPR#3424

Loading of libcrypto.so is not supported on a HP-UX build (PARISC and Itanium)

OPR#3429

DQP is not handling View definition format of 5.5 SP2 release

OPR#3438

dam_addValToRow reports error when BIT and TINYINT field values are provided as C data type "char"

OPR#3441

Fail Over and Load Balancing is not working from UNIX (Solaris) client to Windows Server

OPR#3449

Correlated queries are not supporting Views

OPR#3462

Query translation is not correct when multiple views are used. Related to alias being generated for translated view subqueries.

OPR#3464

Native error code is not returned correctly on Solaris

OPR#3467

Union reports invalid results when union queries are Joins and FetchBlockSize is smaller than result set size

OPR#3471

Once TableRowset size exceeds limit, DAM should disable TableRowset for future calls

OPR#3474

SQLError should return SqlState as a null terminated string

OPR#3480

Join queries without INNER qualifier gives syntax error

OPR#3484

dam_describeCondEx is not returning correct length for BIT and TINYINT types

OPR#3485

Queries with substring functions are not returning data going to 64-bit server on Sun Solaris

OPR#3486

"TraceOptions=all:200" in the Server section of openrda.ini causes trace lines to be produced in sqlserv.c and tp0tcp_s.c

OPR#3489

A too long SQL statement causes a crash in DAM

OPR#3490

getString() call in JDBC for a string > 4096 characters causes an exception

OPR#3491

Disk cache reports Invalid xo datatype (247) when query has WVARCHAR data on z/OS and AIX

OPR#3498

Subquery in FROM clause - Issue when set functions in subquery are used in Search condition of outer query

 

Connect any application to any data source anywhere

Explore all DataDirect Connectors

A product specialist will be glad to get in touch with you

Contact Us