Home Partners Company

OpenAccess SDK 5.5 SP2 (December 2006)

  • 64-bit support on additional platforms - Support 64-bit SDK on Windows and HP-UX/Itanium. Support 64-bit ODBC driver on Windows.
  • Enhanced SQL Support - Support CASE expression, CONVERT and CAST functions, and SELECT query without FROM clause.
  • Enhanced data type support - Support BIT and TINYINT data types.
  • Hybrid query execution mode - allow IP to operate in normal or pass through mode on query by query basis.
  • Large file support - Disk Cache module can now take advantage of large file system on Windows.
  • Flexible handling of custom scalar function evaluation - provide scalar function value as column value.
  • Improved Schema support for multiple catalogs - Allows query validation to be based on current qualifier and owner. Allow system table schema to use current qualifier.
  • OpenSSL support on additional platforms - This version extends support for OpenSSL to AIX 5.3 and HP-UX 11.23 on Itanium.
  • Enhancements and bug fixes - over 20 enhancements and over 30 bug fixes.

OPR#767

DAM: Expose TOP N select option to IP

OPR#962

DAM: Support condition expression CASE

OPR#2238

DAM: Support CONVERT and CAST functions

OPR#2849

DAM: Allow IP to get OA_SUPPORT information of column using dam_getColOption

OPR#2969

DQP: Support set functions (aggregate functions) in expressions in DQP mode

OPR#2972

SDK: Allowing the SQL IP to handle certain OA_INFO calls

OPR#3048

NDAM: NDAM should support customization of QUALIFIER_TERM and OWNER_TERM using ip_getInfo

OPR#3083

SDK: Support option to run Installations in Silent Mode

OPR#3148

SDK: Support SQL_BIT and SQL_TINYINT data types

OPR#3149

JDBC: Support NULL data type in SQL IP mode

OPR#3150

DAM:Allow IP to map scalar function as a column. Value can be passed when building the row

OPR#3172

ODBC: Support SQLCancel in Local mode with DAM IP

OPR#3178

ODBC: Allow Custom Driver connect interface to return error messages

OPR#3250

DAM: Support SELECT query without FROM clause

OPR#3287

DAM: Support Large (>2GB) disk cache file on Windows

OPR#3288

DAM: Allow IP to get column handle by searching for it by name and type

OPR#3303

DAM: Allow IP to check if target row matches condition list returned from dam_getSetOfConditionListsEx

OPR#3310

DAM: Support Qualifier(Catalog) of System table to be same as current qualifier of the connection

OPR#3334

DAM: Allow query validation to be based on current Qualifier

OPR#3358

SDK: Support option to disable hex tracing of Unicode messages in log files

OPR#3401

SDK: Include milliseconds in the time-stamps of the trace messages

OPR#2578

DAM: Views do not support DISTINCT quantifier

OPR#3129

WRDAADMIN: wrdaadmin is not allowing 0 for MAX_SIZE setting of Disk cache options.

OPR#3181

SDK: Conversion from a MBCS char string (SQL_CHAR/SQL_VARCHAR/SQL_LONGVARCHAR) to SQL_C_WCHAR is not correct

OPR#3207

Java SDK: In JSQL IP mode, PREPARE does not result in column spec or parameter specs being returned

OPR#3209

Java SDK: JSQLDRV is not passing the COL ATTRIBUTES returned by the JSQL IP up to SQLS layer

OPR#3211

Java SDK: SQLColumns call to JSQL layers truncates number of columns to 12 -- ODBC 3.x requires more columns

OPR#3219

Java SDK: setInfo in JDBC IP is not handling the query timeout and max rows settings

OPR#3258

ODBC: iusql program that comes with unixODBC driver manager fails to connect to OpenAccess ODBC - Database keyword not found error

OPR#3279

SDK: Binding of parameters to SQL_WVARCHAR or SQL_WCHAR is limited - support basic types to WCHAR and WVARCHAR

OPR#3286

DAM: Comments in original query string are not retained when query is transformed to remove subquery in FROM (or View query)

OPR#3297

SDK: ODBC driver cannot be loaded (system error 998) when full tracing is enabled and environment variables (PATH, CLASSPATH) are larger than 1000 bytes

OPR#3311

DAM: Subquery validation to check if query result has single result is not valid. Its applied even to validate subqueries in FROM clause of nested queries.

OPR#3312

DAM: Support correlated column reference that is not qualified by parent table name

OPR#3314

DAM: Exists and Unique predicates are not handled in subquery translation

OPR#3315

DAM: Correlated columns are not properly translated in subquery translation

OPR#3316

SDK: Query on system tables reports Unicode license error when table name is qualified

OPR#3318

ODBC: Invalid license error reported by Local ODBC driver - Key is not valid for more connections

OPR#3319

DAM: CREATE TABLE DDL command is not correctly handling multi-column index

OPR#3342

ODBC: SQLSetConnectAttr(SQL_ATTR_MAX_ROWS) is not supported

OPR#3357

ODBC: Modify SchemaQualifier configuration key as SchemaOwner

OPR#3342

ODBC: SQLSetConnectAttr(SQL_ATTR_MAX_ROWS) is not supported

OPR#3344

SDK: Install should use Windows drive for default install folder

OPR#3357

SDK: Modify SchemaQualifier configuration key as SchemaOwner

OPR#3361

OLE DB: OLE DB is truncating last unicode character when returning data for WLONGVARCHAR fields

OPR#3365

OLE DB: OLE DB Provider returns garbage data for WVARCHAR field with zero length

OPR#3366

SDK: Zero length Binary field causes connection failure on Client

OPR#3368

DAM: Join query - incorrect processing of search condition involving OR expression with AND expression on separate tables

OPR#3369

DAM: Result column name of Scalar function mapped as column is not being reported properly

OPR#3373

DAM: Union query returns empty results when the subquery has search condition which is always FALSE

OPR#3374

DQP: Query with CASE expression containing constant condition crashes

OPR#3378

SDK: Crash in oaisql on Itanium 64-bit HP-UX -- Bus error in rda_cliGetClientAddress

OPR#3380

SDK: Join query with multiple views where only some views are transformed and some pre-evaluated is not handled correctly

OPR#3383

DAM: Join query with multiple views where only some views are transformed and some pre-evaluated is not handled correctly

OPR#3384

JDBC: getInt method in JDBC is not correct for 64-bit - in testing EMPNO value is returned as 0

OPR#3385

JDBC: Logging of JDBC driver on HP-UX/Itanium goes to console

OPR#3386

SDK: rda_aeRcv causes crash when handling P_S_ABORT event

OPR#3391

DAM: UNION is returning ALL results when the UNION subquery has empty results

OPR#3400

SDK: Problem with find command during install on Linux

OPR#3403

DQP: DQP is not correctly formatting dateadd and datediff functions in query being passed to backend DB

OPR#3416

NDAM: Calling .NET scalar function on a new connection can cause a crash

OPR#3402

ODBC: ODBC Driver setup DLL is not supporting OPENRDA_INI environment variable

OPR#3421

DAM: Compare function is not set. Issue with IN condition dam_getSetOfConditionListsEx creates UNION condition lists

OPR#3422

DAM: Provide option to enable support for Locale specific decimal character in query literals

OPR#3423

Standard version of Local ODBC SDK 5.5 SP1 and 5.5 SP2 is not working with SQL Server 2005

OPR#3426

DAM: Binary Schema is not correctly reading OPEN

patch-whats-new

Read Next

What's new