OpenAccess SDK 5.6 (July 2007)

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