DataDirect OpenAccess SDK Release History

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

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 seperate 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 OPENRDA.INI settings

OPR#450

DAM Allow Length, Precision & Scale to be specified for Scalar Function Return value

OPR#1190

ODBC:Return data type name column attribute from IP to client

OPR#2886

JDBC Driver:Extend URL for standard & custom attributes

OPR#3017

SDK:Trace "Log File Truncated" as last message in the log file

OPR#3039

SDK:Support Query on View objects implemented by IP

OPR#3060

SDK:Allow IP to use indexes only for index optimization and not for exposing as Statistics in Schema API

OPR#3061

SDK:Index conditions with non-constant Scalar functions on outer table columns should be exposed to IP

OPR#3071

SDK:Support Binary data types in disk cache

OPR#3076

SDK:Improved support for subquery in FROM clause. Remove limitations caused due to query transformation

OPR#3088

SDK:Logging -- even if only the errors are logged we need to write out header in log file with version information

OPR#3104

SDK:Support Scientific E notation in Numeric literals

OPR#3106

SDK:Allow validation of License Key file for a specific ProductName

OPR#3108

SDK:Allow IP DDL Interface to handle CREATE VIEW, DROP VIEW commands

OPR#3113

DQP:DQP needs to allow configuration of scalar function format in query string for backend database

OPR#3127

SDK:Support correlated subquery in UPDATE query

OPR#3141

SDK:Allow scalar functions with no arguments to be used as identifiers (skip the empty function bracket) in query

OPR#3143

ODBC Driver:SQLColAttribute() for Catalog, Schema and Table Name should be supported - SQL_DESC_CATALOG_NAME, SQL_DESC_SCHEMA_NAME, SQL_DESC_TABLE_NAME

OPR#3147

SDK:Improved support for Views. Remove limitations caused due to query transformation

OPR#3163

SDK:ODBCISQL should allow making multiple connections

OPR#3165

SDK:Hex numeric literals should be supported in query string

OPR#3221

SDK:Join Order Optimization based on Search Condition should allow index check on inner table to accept index on join condition or a search condition on inner table

OPR#3264

SDK:Allow DQP to reverse translate simple scalar function values used as condition on translated columns

OPR#3268

Support SQLColAttribute(SQL_DESC_OCTET_LENGTH) in ODBC 3.x API

OPR#1185

DAM:All computed expressions (scalar functions etc) in inner GROUP BY must also be in outer SELECT - limitation of subquery in FROM clause

OPR#1398

ODBC:SQL_VARCHAR to SQL_DATE conversion is not supported

OPR#2253

SDK:NULL value specified for VARIANT column is not being handled correctly

OPR#2298

SDK:CHAR parameter of exact length 32000 causes crash

OPR#2351

ODBC:iODBC Driver Manager 3.51.1 build on Solaris8 is not exporting ODBC W API (SQLPrepareW etc.)

OPR#2374

DAM:Long formatted name for result column causes crash due to buffer overflow

OPR#2944

SDK:Conversion of Parameter data from SQL_BINARY/SQL_VARBINARY to SQL_LONGVARBINARY is not supported

OPR#2954

SDK:UID and PWD are visible in RDA event tracing - Connect string contains UID and PWD

OPR#2975

SDK:dam_addError and dam_addErrorW crash if message exceeds XO_ERROR_MESSAGE_LENGTH

OPR#2976

SDK:MSQuery is not allowing query with criteria on TIMESTAMP field to be edited by the Query Wizard

OPR#2981

SDK:Server is not reading LogFileClose trace setting for each connection. Tracing is slow if tracing is enabled after server startup

OPR#2987

SDK:Memory leak in handling of LONGVARBINARY, LONGVARCHAR, WLONGVARCHAR data in non-SQL IP mode

OPR#2992

ODBC Driver:File DSN configuration is not prompting with Custom Connect dialog - SQLDriverConnect used with Driver keyword has same issue

OPR#3005

ODBC Driver:SQL_C_LONG to SQL_SMALLINT conversion error

OPR#3007

SDK:Improve validation of Schema Queries when Unicode Product is not licensed

OPR#3009

SDK:odbcisql crashes when large customconnect command is executed

OPR#3011

ODBC Driver:Use of word with letters PASSWORD in the connect string causes crash in ODBC Driver

OPR#3012

.NET Driver:OaDataReader.GetChars is not returning correct size data

OPR#3023

JDBC Driver:getLong method of oacallablestatement is not handling large numbers correctly

OPR#3033

ODBC Driver:Second connection fails from odbcisql on AIX

OPR#3034

SDK:Pushdown join rowset provided by IP is not being used in cases where consecutive outer join rows have same join column value

OPR#3035

SDK:Support dam_freeRowSet

OPR#3037

SDK:Modify IP support option name of Pass Through query mode to IP_SUPPORT_PASSTHROUGH_QUERY

OPR#3038

SDK:Modify Administration tool to improve handling of MaxFileSize Trace setting

OPR#3040

OLEDB Driver:OLE DB data source uninitialization is not correct when there is failure at the open (uid/pwd) authentication

OPR#3052

SDK:damex_getFirstValExp() is not returning NULL when argument list is empty

OPR#3064

SDK:Timestampadd/dateadd scalar function is not correctly handling operations on TIME fields

OPR#3065

ODBC:SQLGetData Conversion of SQL_TIME to SQL_C_TIMESTAMP should set the date portion

OPR#3069

SDK:Validate Schema to check Column Types passed for Procedure Columns (OA_COLUMNTYPE field of OA_PROCCOLUMNS)

OPR#3070

SDK:Usage of table alias in nested SUBQUERY IN FROM is not being used in transformed query

OPR#3072

SDK:Stored Procedures with Return Value or Output Value causes crash during multiple execution of prepared query

OPR#3080

ODBC Driver:ODBC driver does not support conversion of SQL_VARCHAR to SQL_C_TIMESTAMP

OPR#3081

SDK:RowCount returned by IP Stored Procedure execution causes actual row count reported to be double the result set size

OPR#3096

JDBC Driver:JDBC layer tracing is not enabled on UNIX

OPR#3102

SDK:Quiet Mode argument of OpenRDA Server - syntax is not proper on Unix

OPR#3107

SDK:OA_USERDATA value of TABLE and COLUMN schema is not being returned completely in Schema Queries

OPR#3130

SDK:AL_surDeleteACB causes a crash because it makes unprotected access to a shared UCB list

OPR#3135

JAVA SDK:Calling java scalar function on a new connection can cause a crash

OPR#3138

JDBC Driver:Parameter value set using setString is not being passed correctly

OPR#3139

ODBC Driver:ODBC driver is crashing when SQLBindParameter passes empty string (SQL_C_CHAR) for date/time Parameter type SQL_DATE/SQL_TIME

OPR#3151

SDK:ODBCISQL is truncating Unicode data results (WCHAR/WVARCHAR) when displaying results

OPR#3155

SDK:On solaris server exits if the number of files (nofiles setting) is exceeded

OPR#3156

JDBC Driver:Subsequent execution of prepared statement with multiple results returns a null result set

OPR#3160

SDK:dam_getSetOfConditionListsEx does not set *pbPartial correctly when the IP_INFO_COND_LIST_NORMALIZATION_LIMIT is reached

OPR#3162

SDK:Server should not exit if a socket or file resource is not available

OPR#3164

SDK:Hex value passed as string literal in query is not correctly converted for short binary data fields

OPR#3167

SDK:Modify dam_describeCondEx to return proper length for all data types

OPR#3168

DAM:DAM is not correctly handling parameters during repeated query execution if parameters are converted

OPR#3170

ODBC:ODBC driver is returning -1 (SQL_NULL_DATA) as length when SQL_WVARCHAR data cannot be converted to SQL_C_CHAR

OPR#3173

SDK:Crash during repeated execution of dynamic stored procedure if procedure only has Result columns and no input/output arguments

OPR#3174

DQP:Unique identifying column is being added as extra column to queries in DQP mode

OPR#3180

JAVA SDK:Java SDK has incorrect implementation for dam_setInfo(DAM_INFO_STMT_IP_CONTEXT)

OPR#3181

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

OPR#3214

JAVA SDK:Certain JDAM calls result in the creation of Global References that are not freed

OPR#3231

SDK: Could not found RdaCli TLS for 2E4 thread - Message logged when using SQL reporting services

OPR#3237

SDK: Binding of parameters from SQL_C_WCHAR to SQL_WVARCHAR is not handled correctly - we copy extra bytes

OPR#3238

SDK: Binding of parameter from SQL_C_WCHAR to SQL_TIME, SQL_DATE, SQL_TIMESTAMP copies extra bytes and fails at RDA layer

OPR#3253

ODBC: CustomProperties and other information read from odbc.ini is limited to 127 on UNIX

OPR#3265

SDK: DQP should not pushdown search expression with scalar functions that have translated column as Arguments

OPR#3272

Problem with subquery in FROM clause when IP supports Views

OPR#3273

setlocale usage on Unix is not correct when locale not set in openrda.ini

OPR#709

SDK: Support SQL_BINARY and SQL_VARBINARY data types

OPR#783

SDK: Support SQL_LONGVARCHAR and SQL_WLONGVARCHAR data types

OPR#1527

ODBC: Support CustomProperties on Non-Windows platforms

OPR#1862

DAM: Support TIMESTAMPDIFF and TIMESTAMPDD scalar function ( defined by ODBC)

OPR#2051

SDK: Allow Numeric results to be rounded

OPR#2070

JAVA SDK: Enhance Example1 Java IP to support INSERT/UPDATE/DELETE queries

OPR#2130

SDK: Allow IP to get entire search expression as normalized list of condition list - walk list using passthrough API

OPR#2265

SDK: Error prefix customization

OPR#2270

JSQL: BLOB parameter support

OPR#2306

SDK: Data encryption ( AES/Rijndael) for client/server communications using OpenRDA protocol

OPR#2320

DAM: Support Comments in Query string -- (comment) /* comment */ - extend it for HINTs

OPR#2352

ODBC Driver: Support SQLGetDiagRec

OPR#2373

SDK: Support Verbose mode SQL engine tracing in Server and Local Drivers

OPR#2380

SDK: Improve performance of logging

OPR#2473

SDK: Support configurable SQL_ATTR_TXN_ISOLATION and SQL_OWNER_TERM

OPR#2516

SDK: Allow ip_endTransaction to return error message in addition to Native error code

OPR#2561

SDK: Allow setting default query timeout value in openrda.ini and through connection string keyword

OPR#2664

ODBC Driver: Support conversion to SQL_C_TINYINT

OPR#2670

JAVA SDK: Distribute JAR for Java SDK

OPR#2687

JDAM: Extend JDAM to include full API for SQL pass through

OPR#2721

SDK: Support Negotiate_DBMS security mode

OPR#2729

SDK: Allowing the Server to return error messages in different languages to handle clients with different locale settings

OPR#2741

SDK: Expose literal expressions involving Multiple & Divide operators to IP

OPR#2743

SDK: Limiting number of errors that get reported per query

OPR#2758

SDK: Support locale specific decimal character in numeric literals

OPR#2768

SDK: Allows configuration of Cryptographic Service Provider when Windows cryptography is selected for encryption

OPR#2775

SDK: Upgrade Install Shield Projects from 6.x to 10.5

OPR#2793

SDK: Use Primary Key and ROWID Pseudo column as Unique index for query optimization

OPR#2795

SDK: Optimize use of memory allocations for small varbinary data

OPR#2799

JDAM: Synchronized changes in DAM and JDAM since SP2 release

OPR#2830

JAVA SDK: Add support for Scalar functions in Java SDK

OPR#2831

JAVA SDK: Support VARBINARY , LONGVARCHAR, and LONGVARBINARY to Java SDK

OPR#2832

SDK: Support ISNULL, NVL scalar functions

OPR#2833

SDK: Allow IP scalar function to get the scalar function name - dam_describeScalar

OPR#2835

ODBC: Clients should be able to select randomly or in sequential fashion the server to connect to

OPR#2836

SDK: Improve join order when join condition is on foreign key table with multiple primary key tables

OPR#2838

SDK: Simplify IP interface registration and custom scalar function registration

OPR#2858

SDK: Allow IP to use DAM API to parse query and get the parse tree details - sqldrv_getQuery

OPR#2884

SDK: Allow Block Join to be used for some of the tables in the join whose join conditions are block join compatible

OPR#2895

SDK: Support UserName (UID) and Password (PWD) strings upto 256

OPR#2898

SDK: Support conditions on Binary Fields

OPR#2950

DQP: Support IP getInfo and setInfo interface in DQP mode

OPR#154

ODBC: ODBC Driver - SQLBindCol - incorrect implementation in one case

OPR#865

SDK: Use aamallocFromPage instead of aamalloc from more places in rdaxidu and other layers to improve decoding speed.

OPR#1028

DAM: DAM should skip normalization of WHERE clause into condition lists for complex expressions

OPR#1435

.NET Driver: Change the name of the namespace

OPR#1487

SDK: Symbols Boolean & BOOL cause conflict with user symbols - build errors on Linux

OPR#1528

SDK: Modify ODBC SQL IP to process AUTOCOMMIT setting in sqlip_setInfo and sqlip_connect

OPR#1534

SDK: ODBCISQL/OAISQL report NULL for fields with large precision

OPR#1805

ODBC Driver: Verification of length argument in Unicode ODBC API as per Microsoft article #294169

OPR#1807

ODBC Driver: Custom.ini in Unicode C/S ODBC install has entries that don't apply to client/server

OPR#1831

SDK: Allow SQL_QUALIFIER_TERM to be customized from ip_getInfo() and not cache in oainfo.ini

OPR#1901

SDK: Display the current LC_ALL locale settings in the log files

OPR#1970

DAM: Move FETCHBLOCK_SIZE, JOINBLOCK_SIZE, RdaStmtOptimizeLevel and SessPollWaitTime from the CLIENT section to Common section in openrda.ini

OPR#1977

ODBC Driver: Allow option for ODBC driver to return SQL_WCHAR as SQL_C_CHAR when SQL_C_DEFAULT is used - Only getting 1 character of string fields in ReportSmith

OPR#2001

SDK: tr_trace should not generate logs for ERROR level when TraceLevel is 0

OPR#2017

OLEDB Driver: OLE DB Driver uninstall is not unregistering the Provider

OPR#2028

SDK: Modify dam_getValueToSet() to return corresponding sizeof the data type instead of XO_NTS

OPR#2044

ODBC DRIVER: SQLRowCount returns -1 when result set size is large

OPR#2050

JSQL: Select Count(*) from table with more then 32000 records returns wrong results using JSQL IP

OPR#2054

DQP: DQP is not pushing down JoinExp when join is processed as a single query

OPR#2064

SDK: Syntax error reported on a mixed join query generated by MSAccess

OPR#2073

SDK: Improve Join Order to continue checking other option even if its finds conflicting FKEY information

OPR#2074

SDK: Improve Join Order to individually check index on join condition for each FKEY/search condition being applied and ignore when there is no match

OPR#2084

JSQL: Java SDK for Solaris - 5.0 SP2 hangs with Squirrel - problem with getTableTypes

OPR#2092

OLEDB: RowsetViewer reports numeric type values as 0.0 when using IOpenRowset::OpenRowset(TYPES)

OPR#2094

OLEDB: RowsetViewer - Using OpenRowset on table with more columns followed by table with fewer columns is not working

OPR#2100

SDK: ODBCISQLW is not printing new lines after error message

OPR#2104

ODBC DRIVER: ODBC driver causes client application to crash when openrda.ini is not found

OPR#2125

DAM: Improve Join Order to process FKEY table first and PKEY table next when index is only on PKColumn and no index on FKColumn

OPR#2132

SDK: Problem with implementation of cToWV

OPR#2136

SDK: DAMISQL on linux (ILINUX 7.3) does not work when Database name is not specified as argument

OPR#2138

SDK: OAISQL on linux (ILINUX 7.3) does not display result column names and echo is also not working

OPR#2157

SDK: Allow ip_endTransaction to return a native error code to the ODBC layer

OPR#2179

SDK: Expose Unicode API to process DCL and DDL commands

OPR#2183

SDK: View operations are not working in Unicode SDK on Linux and Solaris

OPR#2185

JAVA SDK: Start up server java classes must be in package to work with application server

OPR#2186

JDAM: Command line options (like -i) is not working with Java start-up files with server as DLL.

OPR#2192

SDK: DAMISQL on Linux does not display result column names and does not support parameters

OPR#2208

JAVA SDK: Long strings crashes the server - alignment problem in xm module

OPR#2221

JDAM: JSQL Server Crashes on Solaris 8 with Multiple connections.

OPR#2224

SDK: Invalid SQL syntax - using AVG, SUM set functions on non-numeric fields in ORDER BY and HAVING is cauing access violation

OPR#2235

SDK: Numeric literals longer than maximum supported numeric length causes access violation

OPR#2242

ODBC DRIVER: Error setting up CustomProperties while creating ODBC DSN on windows

OPR#2258

SDK: SQLColumns should not expose PSEUDO columns. Allow NULL values to be specified for Psuedo columns during INSERT

OPR#2262

JDBC Driver: Error Message Prefix Customization in JDBC

OPR#2264

ODBC DRIVER: Application buffer overrun

OPR#2266

SDK: Views and subquery in from clause do not work when identifiers contain # character

OPR#2276

JDAM: JAVA SDK Server (UC Version) SP2 crashes with Multiple connection in the first time using OAStressW program.

OPR#2280

DAM: Query with BETWEEN reports error when value of end condition is NULL

OPR#2281

DAM: Query with BETWEEN join condition causes error to be reported - "Invalid condition. Can't reverse"

OPR#2282

ODBC DRIVER: SQLGetInfo(SQL_ACTIVE_STATEMENTS) causes crash if application calls this before SQLConnect and tracing is enabled

OPR#2295

JAVA SDK: Java Server (JSQL) crashes when query has string data longer than 255 and returns more than one record

OPR#2300

DAM: Scalar function week is not returning correct result

OPR#2302

DQP: Views with large query string cause crash due to buffer overflow

OPR#2319

SDK: OpenRDA Server causes crash due to memory leak on repeated execution of OA Special Commands - SetConnectOption(AUTOCOMMIT)

OPR#2343

SDK: Connect string and authorization tracing issue

OPR#2350

ODBC Driver: Error reporting is not working when OpenRDA Unicode ODBC driver 5.0 SP2 is used with iODBC Driver Manager 3.5

OPR#2354

.NET: Change System.Data.OaClient name space

OPR#2365

DAM: Join Problem - Incorrect processing when mixed inner join expression has condition on outer join column

OPR#2385

SDK: OpenAccess IP Demo - Build errors on Linux

OPR#2411

JSQL: Pass AUTO_COMMIT option to JSQL IP

OPR#2416

SDK: Template/samples for Unicode IP - Update example IPs to expose both UNICODE Interface and NO_UNICODE Interface

OPR#2434

SDK: Allow new logging settings to be read during connection

OPR#2442

DQP: DQP mode - IN predicate should not be transformed into to OR condition list

OPR#2454

SDK: END_QUERY is not being called for all tables in JOIN when query execution fails in disk cache

OPR#2456

SDK: sys_deps.h build error

OPR#2488

SDK: Connections at fast rate cause server to exceed its limit of five backlog in the listen() call

OPR#2509

JAVA SDK: JVM_OPTIONS values that contain "-" characters do not get parsed correctly

OPR#2513

JAVA SDK: Java Server has a limit of 5 options in JVM_OPTIONS

OPR#2522

SDK: Join queries between IP exposed tables and System Tables is not supported when IP does not implement START_QUERY and END_QUERY

OPR#2524

JAVA SDK: Make Java samples (which are distributed as part of installation) thread safe

OPR#2527

NDAM: Make NDAM samples thread safe

OPR#2553

SDK: Executing a order by/group by query on a view crashes when order by column has string literal

OPR#2554

DAM: Binary Schema mode TABLE_PATH is not compatible with DB3 IP

OPR#2566

SDK: Modify ODBCISQL to set SQL_QUERY_TIMEOUT only if user explicitly uses QueryTimeout command

OPR#2580

SDK: Modify tracing to provide timestamp information for Error messages independent of the tracing level

OPR#2596

ODBC Driver: Data Type mismatch error reported by GROUP BY, ORDER BY post-processing options when column value gets converted

OPR#2597

SDK: DDL and nested query operations hang due to nested locking of DB3 IP Mutex from same thread

OPR#2611

SDK: Enhance RDA Admin for encryption options

OPR#2616

SDK: Enhance trace level setting from OpenRDA Admin to include ERROR|SNO|FATAL and to rename the levels

OPR#2621

SDK: Terminating a connection at server due to wrong TPDU version causes client to hang on Linux

OPR#2644

ODBC Driver: UID/PWD limit in default Driver login dialog is 32

OPR#2645

SDK: Handle leak in the server

OPR#2649

SDK: JDBC fixes related to Application Server

OPR#2655

SDK: Conversion error reported when query uses disk cache

OPR#2685

SDK: Compile of memory IP on Linux AS 3.0 /x86_64 gives warnings and errors in strnicmp

OPR#2695

DQP: DQP with changes to support large query string has memory leak

OPR#2704

SDK: oaisql depends on oaodbc32.dll.

OPR#2709

SDK: Numeric strings longer than 32+5 (37) cause client side parsing routines to report an error

OPR#2710

SDK: Numeric value size is not validated at the SQLS layer

OPR#2727

SDK: oaisql hangs during exit

OPR#2730

SDK: Socket probem on Linux with select()

OPR#2736

ODBC Driver: Calling SQLPrepare multiple times without a SQLFreeStmt(SQL_CLOSE) or SQL_DROP in between keeps increasing number of columns reported by SQLNumResultCols

OPR#2740

SDK: Precision of column data is being lost when query involves conversions

OPR#2742

SDK: Expose Join condition that has expression on outer table columns to IP - dam_describeCondEx

OPR#2745

SDK: Remove TIMESTAMP level from ERRORS using rdaadmin

OPR#2752

SDK: Tracing - function sqlu_createResSpec is not tracing the argument values for precision, etc.

OPR#2753

SDK: odbcisql results in RDA_CONFIG not set error when openrda.ini file is in C:\WINNT folder

OPR#2757

SDK: String literal in query should be treated as Unicode literals even without N prefix

OPR#2764

SDK: OpenOffice on UNIX fails for SQLTables

OPR#2773

SDK: Solaris hanging - when thread creation fails and/or acccept fails

OPR#2789

ODBC: Change meaning of PromptForUID

OPR#2796

SDK: Function sqlu_addResVal does not free data chain for W LONGVARCHAR

OPR#2800

SDK: Scalar function round is not working correctly for negative numbers

OPR#2801

ODBC: odbcisql problem displaying wide chars

OPR#2811

SDK: crash in wrdadml.exe, version 5.0.81.0

OPR#2812

ODBC Driver: Unicode ODBC Driver does not report SQLMoreResults correctly when application calls SQLFreeStmt(SQL_CLOSE) before getting all results

OPR#2814

JAVA SDK: Propagate the Java IP return code as is without doing mapping

OPR#2816

DQP: Extend support for unicode literals without N prefix in DQP mode

OPR#2824

SDK: Modify ODBCISQL to allow control of Unicode data display with separate options

OPR#2825

SDK: Use of any word in the connect string with the letters "type" in it confuse the sqls_attach function

OPR#2827

JSQL: SQL State shouldn't be null

OPR#2837

JDBC Driver: OpenAccess jdbcisql & REPEAT command

OPR#2839

JSQL: OAServer stop running

OPR#2840

JAVA SDK: Enhance SQL IP getColVal call to include the type of the column being accessed so that JSQL can be optimized

OPR#2841

SDK: Modify damex_describeVal to expose length of the literal value - required for Binary data types

OPR#2847

SDK: "disk1" should have new files of IS 10.5 during installations of SDK

OPR#2853

SDK: Char data types returned to SQLS through GET_COLVAL shoud not require NULL termination

OPR#2855

SDK: Improve handing of SQL_LONGVARBINARY data in non-SQL IP mode

OPR#2859

SDK: OpenRDA Administration tool and Trace settings

OPR#2861

ODBC: Accesing VARBINARY/BINARY from Crystal and MS Access requires Binary to WCHAR conversion

OPR#2862

SDK: Modify ODBCISQL to bind DATE, TIME, TIMESTAMP as SQL_C_DATE, SQL_C_TIME, SQL_C_TIMESTAMP

OPR#2863

JSQL: Schema query problem with ORDER BY clause not using alias name

OPR#2864

OLEDB Driver: Event viewer message

OPR#2865

SDK: Memory leaks for key buffer

OPR#2866

SDK: Crash when processng INSERT query

OPR#2868

SDK: Primary Key information should be requested using DAMOBJ_TYPE_PKEY

OPR#2871

SDK: Install the IS 10.5 project during SDK install

OPR#2877

SDK: rdaadmin changes for LogFileClose option

OPR#2888

ODBC: Failure of VARCHAR to WCHAR when getting data in chunks using SQLGetData

OPR#2894

SDK: END_QUERY error is not being reported for JOIN queries

OPR#2906

SDK: Memory leak with conversion of column value when the data type is not same as column data type

OPR#2907

ODBC Driver: Output length for std. ODBC driver isn't set properly.

OPR#2910

RDA: Client crash on SCO

OPR#2912

SDK: Query on View with WHERE clause and GROUP BY report syntax error. Same issue with nested subquery in FROM clause

OPR#2915

SDK: Modify Static Schema implementation to support both ODBC2x and ODBC3x client applications

OPR#2917

SDK: ODBCISQL/OLEDBISQL should set program locale based on openrda.ini configuration

OPR#2920

ODBC: odbcisql is not showing Spanish character correctly

OPR#2928

SDK: Installation missing LogFileClose entry in openrda.ini

OPR#2929

SDK: Installation icon in Add/Remove program

OPR#2931

.NET Driver: .NET Provider tracing problem

OPR#2932

.NET Driver: NULL value in DateTime problem

OPR#2933

ODBC: ODBC client driver installation problem

OPR#2934

SDK: Rdaadmin creates incorrect openrda.ini file

OPR#2935

ODBC: ASCII ODBC Driver problem

OPR#2955

.NET Driver: 5.0 SP2 .NET Data Provider is not working with 4.8 server

OPR#2956

ODBC: Remove -p option from odbcisql

OPR#2957

ODBC: SQLColAttribute(SQL_DESC_TYPE_NAME) is not reporting results when data type is date/timestamp types (SQL_DATE, SQL_TIME, SQL_TIMESTAMP)

OPR#2958

SDK: ODBCISQL is not supporting Unicode UID (username), PWD (password) and custom connect string

OPR#2959

SDK: Unicode error messages generated during connect are not being handled correctly

OPR#2960

SDK: Nested subquery has a limit of 256 for each column definition

OPR#2963

.NET Driver: Multiple results is not working

OPR#859

SDK: Web services - design a solution to allow any data source to be queried using SOAP and XML.

OPR#1138

DAM: Add new API in JDAM

OPR#1357

SDK: Make JAVA (JDAM) IP Unicode

OPR#1416

SDK: Allow server configuration parameters like Port to be passed as command line arguments

OPR#1559

DQP: Support Stored Procedures in DQP SDK

OPR#1596

ODBC Customizer: Customizeable ODBC to ODBC Bridge

OPR#1606

SDK: Allow tm_trace to disable printing time in the logs

OPR#1620

SDK: Sample IP for accessing C# objects through C++ extensions for .NET

OPR#1633

SDK: Modifying ISQL output to indicate MAXROWS

OPR#1661

SDK: Example of table expression push-down in C++

OPR#1686

SDK: XA transaction support in OLE DB and JDBC

OPR#1691

SDK: Allow HQUERY of the current table being processed to be retrieved in regular IP mode

OPR#1708

JAVA SDK: Optimize JSQL IP to use fewer object create/destroy opetations when fetching data

OPR#1724

ODBC: Implement a component oaMTS to enable OpenRDA ODBC driver and others to participate in distributed transactions

OPR#1784

DAM: Reduce usage of Global Mutex ( BEGIN_GLOBAL_SERIALIZE) in DAM.

OPR#1818

JDBC: Customization of JDBC URL subprotocol

OPR#1874

SDK: Allow IP to remove error added by DAM

OPR#1916

ODBC: Allow UID/PWD to be prompted when using NTLM for authentication

OPR#1977

ODBC: Allow option for ODBC driver to return SQL_WCHAR as SQL_C_CHAR when SQL_C_DEFAULT is used - Only getting 1 character of string fields in ReportSmith

OPR#54

DAM: Does not verify the size of NESTED SubQuery used in COMPARISON PREDICATE

OPR#331

DAM: LEFT OUTER JOINS on multiple tables ( t1, t2, t3 where t1.c1=t2.c1 and t1.c2=t3.c2) is not implemented properly

OPR#1316

DAM: Multiple Result Sets is not working when Paging is disabled (UsePages=0)

OPR#1364

DAM: UNION subquery in FROM clause is not supported

OPR#1415

ODBC: 3.50 ODBC application crashes in SQLColAttributes when use with 2.0 ODBC driver

OPR#1462

OLEDB: LinkedServer problems with OpenRDA OLEDB provider

OPR#1493

JDBC: JDBC driver is not reporting Native error

OPR#1548

OLEDB: Nested transaction should allow in the distributed transaction

OPR#1561

ODBC: odbcisql display wrong time when command is part in multi-line

OPR#1567

SDK: Effective use of all CPU on a multi-processor Solaris system

OPR#1569

SDK: Trace level 0 should not log ERROR messages

OPR#1572

SDK: ODBCISQL is truncating the Numeric values to length of precision instead of precision+2

OPR#1575

SDK: sl_stristr in sys_deps.c uses sl_strdup followed by a free() - this causes problem when using other memory managers

OPR#1581

ODBC: Unicode driver is not handling BindParameter of Numeric data bound as SQL_C_WCHAR correctly

OPR#1582

JSQL: Parallel connections on multiple processor crashes the server

OPR#1585

DAM: Static Schema DDL is not setting up OA_FKEYS information correctly

OPR#1588

ODBC: SQLColAttribute(SQL_COLUMN_DISPLAY_SIZE) for NUMERIC fields is reporting the PRECISION causing data to be truncated

OPR#1589

DAM: Queries processed using Disk cache return fewer records. Records from last block are missing.

OPR#1594

JAVA SDK: Local ODBC for JDBC fails on disconnect when applications use a single connection on different threads

OPR#1604

ODBC: Customizer MS Access returns -7778 error during connection

OPR#1605

SDK: Remove calls to ftime() from ai_do_rcv in server mode

OPR#1607

ODBC: Customizer ODBC Customizer SDK for SQL Server - ASCII

OPR#1611

SDK: Make tm_tracew behave like tm_trace - remove limitation of just one argument

OPR#1616

ODBC: Core dump - problem with dam_getOptimalIndexAndConditions handling of multi-column index conditions

OPR#1621

DAM: Memory IP - memory leak when JOINS are processed

OPR#1635

SDK: Make Schema API dam_add_damobj_table, dam_add_damobj_column etc C++ compatible

OPR#1658

DQP: DQP should connect to backend Database when needed

OPR#1663

OLEDB: Nasty Bug in updatable recordsets - Memory overwrite for ulColumnSize

OPR#1664

ODBC: ODBC 3.5 driver's value for SQL_SQL92_PREDICATES needs correction

OPR#1667

SDK: Join Condition of nested join queries not being parsed correctly

OPR#1668

SDK Block Joins are not handling conditions in JoinExp correctly

OPR#1674

SDK: dam_allocRow() causes crash when we cannot allocate memory

OPR#1692

ODBC: SQLDriverConnect() in Unicode Driver is not handling ConnStrOut (NULL handle and Valid Handle)

OPR#1698

SDK: Problem with OaMbsToWcs

OPR#1719

SDK: HAVING clause of subquery in FROM clause is ignored

OPR#1747

JSQL: JSQL changes for JVM_OPTIONS and using optimized GetColval methods

OPR#1756

SDK: Server hangs on SMP

OPR#1767

SDK: Pentium 4 with hyperthreading -- does it appear as two CPUs - if so then licensing of desktop has to allow it

OPR#1805

ODBC: Verification of length argument in Unicode ODBC API as per Microsoft article #294OPR#169

OPR#1814

DAM: Use of global mutex (BEGIN_GLOBAL_SERIALIZE)

OPR#1823

JAVA SDK: Validate UserName and Password in JAVA Memory IP.

OPR#1826

SDK: Scalar functions on non-grouping column not allowed in HAVING clause - check for set functions is not handled correctly

OPR#1837

SDK: Create a test table with the weird characters we support for table name and columns -- like "/"

OPR#1842

RDA: Fork related code and signal handling should not be executed in client mode or when forking is off

OPR#1857

SDK: Block Joins with Table Rowsets should allow IP to get conditions that exclude Join Conditions

OPR#1869

SDK: Two problems - Problem with conversion of E-notation zero value and behavior of MOD scalar function

OPR#1875

SDK: Scalar functions return invalid results - problem related to conversion of scalar function arguments

OPR#1877

OTM: URL stress -- execute requests to a HTTP server using the specified URL

OPR#1885

OLEDB: OLE DB layer in 8-bit version should allow multi-byte character strings for command and parameters

OPR#1895

SDK: TableRowset processing should not require IP to process Index conditions

OPR#1902

OLEDB: Enable setting of LOCALE using entry in Openrda.ini (ASCII version)

OPR#1921

JDBC: Empty string comes as NULL

OPR#1933

SDK: Modify Sample IPs distributed with SDK and Java SDK to use "_" in table names

OPR#1937

JDBC: JDBC Driver is Truncating colum name at 64 instead of 128

OPR#1938

JDBC: JDBCISQL - Negative rowcount is reported as 0

OPR#1954

SDK: SQLStatistics information is not returning SQL_TABLE_STAT when UNIQUE filter is set to SQL_INDEX_UNIQUE

OPR#1955

SDK: WRDAADMIN does not support command line option "-i openrda.ini" for specifying OPENRDA_INI

OPR#1956

SDK: Server is not shutting down when client is connected

OPR#1959

SDK: Problem with openrda.ini that has no [client] section - wrdaadmin on Server install reports error

ATIqa01050:

JDBC: Port JDBC SDK on HP-UX11

ATIqa01790:

JDBC: Remove JDBC SDK limitation

ATIqa01791:

JDBC: Unicode version of JDBC SDK

ATIqa01793:

SDK: Unicode changes

ATIqa02311:

SDK: Allow the IP to associate a void * with column handles - ICOL_DA

ATIqa02320:

ODBC: Pass ODBC DSN value as part of User Connect String that is passed to the IP

ATIqa02350:

DAM: Join Order Optimization based on Search Condition should verify that inner tables have indexes defined on the join columns

ATIqa02372:

.NET: Support Unicode

ATIqa02409:

DAM: Scalar function registration is optional in passthrough mode

ATIqa02424:

DAM: Support expressions in ORDER BY clause

ATIqa02440:

SDK: Subset of autotest distribution

ATIqa02486:

SDK: Support the use of DDL commands for static schema management

ATIqa02487:

SDK: Support scalar functions sign() and datediff()

ATIqa02503:

ODBC: ODBC API enable/disable flags for SQLExtendedFetch and SQLMoreResults

ATIqa02559:

DQP: Optimization of queries targetted to a single database

ATIqa02561:

DQP: Enhance jdeDirect IP to support views

ATIqa02562:

DQP: Test DQP with 8-bit support in 5.0U build in preparation for unicode support in jdeDirect

ATIqa02572:

SDK: JAVA SDK limitations

ATIqa02578:

ODBC: Uninstalling OpenRDA ODBC Driver should remove all current DSNs that are based on it

ATIqa02617:

JDBC: Support calling of stored procedures that return values -- ? = call test()

ATIqa02619:

SDK: Optimize binary schema storage and lookup

ATIqa02623:

SDK: Support OpenAccess API SDK for Java with the sample JDBC IP on Solaris

ATIqa02626:

SDK: Support unicode version on Windows 95/98

ATIqa02628:

SDK: Support customizing error message file for Unicode build

ATIqa02631:

ODBC: Increase custom connect property size from 127 to 255

ATIqa02632:

SDK: Support openrda.ini customization using custom.ini

ATIqa02633:

SDK: Support custom file distribution using IS 6.0

ATIqa02644:

DAM: Support expressions in GROUP BY and ORDER BY

ATIqa02653:

DAM: Support Option to hide Qualifier and Owner in Catalog query results

ATIqa02670:

SDK: Porting JSQL IP on Solaris

ATIqa02679:

SDK: Port JDBC on digital unix

ATIqa02680:

JDBC: Make JDBC ISQL interface same as other ISQL

ATIqa02681:

SDK: Prepare JDBC user's guide

ATIqa02682:

JDBC: Executiion of query in the loop with same stmt, returns null result set

ATIqa02685:

SDK: Make JSQL IP Unicode enable

ATIqa02686:

SDK: MsQuery failed with Japanese character

ATIqa02687:

SDK: Support Max Rows options in ISQLs

ATIqa02688:

JDBC: Add Local & C/S JDBC in autotest using JDBC isql

ATIqa02689:

DQP: Allow DQP IP to establish connections with backend DB

ATIqa02692:

ODBC: SQLProcedure query call is not use alias in ORDER BY clause

ATIqa02693:

SDK: JSQL server on Solaris crash with CR9

ATIqa02694:

JDBC: Fix input parameter problems

ATIqa02695:

OLEDB: .NET application is not working for binary parameter value more than 32K

ATIqa02697:

SDK: Change server executable name using custom.ini

ATIqa02698:

JDBC: Support SQLWarning object

ATIqa02700:

JDBC: Get connection object from statement object

ATIqa02701:

JDBC: Testing with DbVisualizer 3.1.1

ATIqa02702:

JDBC: Testing with different applications

ATIqa02703:

JDBC: Distribute JAR file instead of classes

ATIqa02709:

SDK: SQLMoreResult is not working with ODBC.NET

ATIqa02710:

SDK: oasconf should accept parameter

ATIqa02711:

ODBC: ODBC driver is not working correctly with ODBC.NET for empty string

ATIqa02713:

JDBC: Testing with JDBC Test 1.03

ATIqa02714:

JDBC: getUpdateCount with Rowset is not returning -1

ATIqa02715:

JDBC: getPropertyInfo() crashes Db Visualizer 3.2

ATIqa02718:

JDBC: Column header of Schema methods is not matching with JDBC specs

ATIqa02721:

JDBC: Testing with Forte for Java CE (Release 3.0)

ATIqa02722:

.NET: Dataset errors for more than one table

ATIqa02723:

JDBC: Testing with TableGen 1.8

ATIqa02732:

JDBC: Testing with SQLConnect 1.6.2

ATIqa02733:

JDBC: Support setObject method

ATIqa02734:

JDBC: Testing with ONE Studio 4 , update 1 (CE)

ATIqa02736:

ODBC: Support configurable SQL_ATTR_CURRENT_CATALOG/SQL_CURRENT_QUALIFIER & SQL_USER_NAME

ATIqa02737:

JDBC: Testing with VisualAge 3.5

ATIqa02742:

DAM: Support Scalar function result type to be based on input argument type

ATIqa02744:

JDBC: Testing with JBuilder 8

ATIqa02748:

DAM: Improve pushing schema search object when IP does not support schema search pattern

ATIqa02752:

SDK: Build single server using JSQL & Java

ATIqa02755:

JDBC: ISO 8859-1 string is not handle properly

ATIqa02757:

JDBC: getxxx(ColumnName) is case sensitive

ATIqa02758:

SDK: QA of Installations

ATIqa02761:

JDBC: getCatalog connect property is not working properly

ATIqa02762:

SDK: Porting JAVA SDK on AIX

ATIqa02763:

DAM: Support DAM_copyRow() to allow IP to copy/clone a result row

ATIqa02765:

DAM: Binary Schema should support Unicode Schema

ATIqa02774:

DAM: Support configurable SQL_DATABASE_NAME

ATIqa02779:

OLEDB: ADO.NEt applciation CLOB parameter values are truncated to 16 bytes

ATIqa02781:

OLEDB: Set ISLONG flag for BLOB/CLOB column/parameter

ATIqa02783:

SDK: Port JAVA SDK on Linux

ATIqa02784:

SDK: Port JAVA SDK on HP-UX 11

ATIqa02789:

DAM: Allow IP to specify multiple values for same column based on Result Alias Name

ATIqa02790:

SDK: We should change our ISQL tool to support same command length as our ODBC Driver.

ATIqa02798:

SDK: OpenAccess SDK and Windows 2000 Terminal Server.

ATIqa02802:

DAM: Simplify Schema Management DAM API

ATIqa02804:

DAM: Improve Block Join Performance when handling Table Rowsets

ATIqa02805:

DAM: Modify scalar functions in Unicode SDK to support both ASCII and WCHAR arguments

ATIqa02811:

ODBC: Improve tm_tracew() function to trace multiple arguments

ATIqa02813:

DAM: Improve result sorting in post-processing options like ORDER BY, DISTINCT

ATIqa02827:

SDK: Check memory leaks in JAVA IP

ATIqa02828:

OLEDB: Numeric & SetLocale problem in Unicode version

ATIqa02829:

ODBC: ODBC server isn't supporting Return value output parameter

ATIqa02831:

SDK: Java doc for JDAM

ATIqa02833:

SDK: JSQL IP server is not working with Oracle's JDBC driver for Oracle

ATIqa02834:

SDK: ISQLs should allow setting query options like SQL_QUERY_TIMEOUT, SQL_MAX_ROWS

ATIqa02837:

ODBC: uery with no parameters reports error if statement has bound parameters

ATIqa02839:

SDK: Tsting of SQL IP with OTS

ATIqa02843:

DAM: Iprove DDL to validate SQL limits

ATIqa02845:

SDK: SQL Windows fails for some DATE/TIMESTAMP value

ATIqa02847:

SDK: JSQL IP crashing on Solaris after any error occurs

ATIqa02851:

ODBC: Paramter execution of query followed by non-parameter execution of a query error out

ATIqa02852:

ODBC: outer join support information is not read from OA_INFO table

ATIqa02853:

ODBC: Transaction error out after connection and before executing any statement

ATIqa02864:

JDBC: Unicode JDBC driver on Solaris has problem

ATIqa02865:

SDK: Passing client version to the server

ATIqa02869:

DAM: Support for multiple schemas during query validation

ATIqa02870:

DAM: Allow IP to specify if numeric strings should be adjusted to match scale

ATIqa02872:

ODBC: ODBC isql (Unicode) is not working on Solaris

ATIqa02881:

SDK: Release OpenAccess User's Guide

ATIqa02882:

SDK: Port Unicode SDK on Linux

ATIqa02884:

JDBC: Profiling & optimizing JDBC driver

ATIqa02904:

ODBC: Support SQLSetConnectOption(SQL_MAX_ROWS) and SQLSetConnectOption(SQL_QUERY_TIMEOUT)

ATIqa02906:

SDK: Query Tool with simple interface for querying ODBC & OLE DB providers

ATIqa02917:

.NET: Support connection string editor

ATIqa02919:

.NET: Support parameter object

ATIqa02920:

OTM: OpenAccess Query Tool should check if OA product is installed

ATIqa02962:

SDK: Pass AutoCommit connect options to the IP Issues addressed by this release

ATIqa01459:

DAM: HAVING clause with no set functions in HAVING or select list is not handled properly when results are disk cached

ATIqa02253:

DAM: Group By on aggregated result field should report error

ATIqa02573:

SDK: Server gets a Disconnect if client system is not on network, SO_KEEPALIVE settings

ATIqa02584:

ODBC: Run microsoft ODBC SDK quicktest and document

ATIqa02609:

SDK: Build on OpenVMS 7.1 with HP TestDrive setup

ATIqa02614:

SDK: Server does not respond to kill -2 after a connection has been performed

ATIqa02629:

SDK: JNI gives ClassCircularError when you execute statement second time

ATIqa02630:

ODBC: Driver crashes when connect string have any attribute name/value more than 50 characters

ATIqa02636:

SDK: OpenRDA Server Service Control Program is not responding in a timely manner to STOP request

ATIqa02637:

DAM: Problem if inner query in FROM clause uses column alias of simple columns in GROUP BY

ATIqa02638:

SDK: Nan and Inf float/double values not handled correctly in C/S version

ATIqa02641:

SDK: Server as DLL is not working with openrda.ini in the same directory as DLL

ATIqa02642:

DAM: NULLs are not being ignored in set functions AVG() and COUNT(column)

ATIqa02643:

SDK: OS/390 linker problem

ATIqa02645:

SDK: Support -q option in server also

ATIqa02647:

DAM: SELECT DISTINCT should not add hidden columns to make results distinct

ATIqa02648:

ODBC: If driver encounters errors writing to log file, it causes application to hang

ATIqa02649:

OLEDB: Blob parameter with BYREF is not supported

ATIqa02652:

DAM: Result type of expressions with set functions in HAVING is not being set correctly

ATIqa02658:

OLEDB: BLOB parameter passed as DBTYPE_VARIANT is not working with .NET

ATIqa02659:

SDK: Trace the PORT number

ATIqa02660:

DAM: Binary Schema is not handling pattern match search conditions

ATIqa02661:

JDBC: Schema functions are not working properly with JBuilder

ATIqa02662:

JDBC: getTableTypes returns more columns

ATIqa02666:

.NET: .NET provider is not working with ASCII server

ATIqa02667:

DAM: Set functions SUM(DISTINCT), AVG(DISTINCT) returns invalid results for short and real fields

ATIqa02668:

DAM: Problem handling NULL WCHAR values when results are written to disk cache

ATIqa02671:

SDK: DAAdmin tool crashes if we try to remove any entry from the database entries

ATIqa02672:

SDK: Porting Unicode on Solaris8

ATIqa02673:

ODBC: Special SQLTables() query won't work with Qualifier set using openrda.ini

ATIqa02674:

DAM: String Scalar functions (REPEAT, CONCAT etc.) are returning the result value as XO_TYPE_CHAR. Causes problem with disk cache if length exceeds 255.

ATIqa02683:

DAM: Modify type number for XO_TYPE_VARIANT to match with Unicode SDK

ATIqa02699:

ODBC: Modify ODBC driver and SDK installs to remove FILE DSN during uninstall

ATIqa02707:

ODBC: SQLGetData( SQL_WVARCHAR --> SQL_CHAR) does not work correctly for multiple calls

ATIqa02716:

JDBC: Install JDK on Digital Unix, HP-11 and SCO OpenServer

ATIqa02719:

DAM: Large Join queries with ORDER BY when processed on disk reports error

ATIqa02724:

DQP: Pushdown mode is not supporting disk cache

ATIqa02725:

DAM: Subquery in FROM clause is not supporting apostrophe in literals

ATIqa02727:

ODBC: Locale sensitive handling of decimal point

ATIqa02730:

DAM: Query with GROUP BY and no set functions when processed on disk does not handle ORDER BY & HAVING correctly

ATIqa02749:

RDA: Memory used for LOGNVARBINARY data field handling are not being released until FetchBlock data is processed

ATIqa02750:

DQP: Allow DQP IP to specify if scalar function should be sent to backend DB

ATIqa02751:

DAM: Catalog Schema Query can cause crash with Dynamic Schema when Views are enabled with FILTER_VIEWS_WITH_QUALIFIER_NAME

ATIqa02753:

DAM: Union queries should not support UNIQUE ROWS option

ATIqa02767:

DAM: COUNT(col) causes crash with Disk Cache queries

ATIqa02768:

DAM: Expressions in ORDER BY cause crash with disk cache queries

ATIqa02769:

ODBC: MS Access shows #deleted when accessing Uni IP with greek or Japanese characters

ATIqa02771:

SDK: Numeric values should not be modified based on the scale of the numeric data type

ATIqa02776:

SDK: Allow 5.0 Unicode ODBC driver to work with 5.0 ASCII server

ATIqa02785:

SDK: Referencing a linked server using four parts in SQL Server causes a full table scan

ATIqa02795:

DAM: HAVING clause is not handled correctly when Having exp refers to columns not in result

ATIqa02797:

OLEDB: DBCOL_SPECIALCOL guid is not return for hidden columns

ATIqa02799:

DAM: DAM ISQL is not supporting "-i" option for openrda configuration file

ATIqa02803:

ODBC: Server compatibility error message improvement (WITH CHECK OPTION violation)

ATIqa02812:

DQP: Problem with formatting of mixed inner & outer join query

ATIqa02823:

SDK: JSQL Server is not linking table with MS ACCESS

ATIqa02824:

JDBC: Check for memory leaks

ATIqa02825:

SDK: Check memory leaks in JSQL IP

ATIqa02841:

DAM: Metadata information (precision, length) of system tables is invalid

ATIqa02844:

DAM: SQL query limit for queries with subquery-in-from or views is not being handled correctly

ATIqa02857:

ODBC: Remove SQL_FLOAT from OA_TYPES so that SQLGetTypeInfo() does not report it

ATIqa02860:

SDK: Time literals as parameters supplied at execution time (DATA AT EXEC) are not normalized

ATIqa02879:

DAM: Group BY when handled by IP causes crash with disk cache queries if group columns are not in select list

ATIqa02897:

SDK: Connect String read from oadrd config file is being truncated to 127

ATIqa02901:

JDBC: Distribute Squirrel with JDBC

ATIqa02902:

SDK: Limitation of GetPrivateProfileString on Unix and spaces before/after =

ATIqa02907:

ODBC: SQLTables is not correctly handling length of TableType argument

ATIqa02913:

DAM: DAM_getValueOfExp() should support conversion of data to WCHAR

ATIqa02918:

DAM: Long column alias causes buffer overrun

ATIqa02923:

SDK: Invalid file handle error in tr_log -- reported by Bounds Checker before a crash

ATIqa02927:

ODBC: SQLDriverConnect returns OutConnectionString with repeated entries for the keywords DSN, UID, PWD etc.

ATIqa02931:

SDK: Merge Unix ODBC/JDBC driver installation guide to SDK

ATIqa02935:

DAM: Modify SQL_DATABASE_NAME/SQL_DBMS_NAME from "OpenRDA DAM" to "OpenRDA"

ATIqa02948:

DAM: Conditions on number (INTEGER, DOUBLE) fields and VARCHAR not supported

ATIqa02950:

DAM: Scalar expressions in outer join conditions cause crash

ATIqa02951:

ODBC: SQLMoreResults is not supported with iODBC Driver Manager 2.x

ATIqa02952:

ODBC: Extended functions value for new ODBC DSN is not getting set correctly

ATIqa02953:

OLEDB: Distributed transaction problem with linked server of SQL Server

ATIqa02958:

ODBC: SQLDriverConnect(SQL_DRIVER_NOPROMPT) causes crash in Redundant Server configuration

ATIqa02967:

DQP: Catalog information is not working with MS Analysis Services

ATIqa02969:

DAM: Double literal values in Scientific E notation are not handled correctly when they do not have decimal point

ATIqa02970:

DAM: Locale Sensitive handling of decimal point in DAM

ATIqa02972:

OLEDB: Bug in OLE-DB provider schema

ATIqa02979:

ODBC: Unicode SQLGetFunctions incorrectly reports support for unsupported functions(SQLMoreResults)

ATIqa02980:

ODBC: Extra Rollback call during disconnect

ATIqa00900:

DDK: Support COMMIT, ROLLBACK & AUTOCOMMITcommands from ISQL

ATIqa01049:

JDBC: Porting JDBC SDK on Linux

ATIqa01507:

DAM: Support Block Joins

ATIqa01508:

DAM: Support detection of condition tht make the search expression always FALSE (Eg: 0=1)

ATIqa02178:

DDK: Build & distribute oaerror.bin file with SDK

ATIqa02187:

OLEDB: Support Data Link connect customization for OLE DB

ATIqa02189:

DAM: Support Subquery in FROM clause

ATIqa02191:

ODBC: Support SQLBrowseConnect

ATIqa02193:

DAM: Support ODBC Escape syntax and expose the Escape clause in dam_describeCond.

ATIqa02194:

ODBC: Support adding customized properties dialogue box to setup data source

ATIqa02195:

DAM: Allow IP to specify if it can handle search patterns in SearchObject of schema function

ATIqa02200:

DDK: Support QUERY_TIMEOUT set option

ATIqa02201:

OLEDB: Support codepage in oledbisql

ATIqa02207:

DAM: Support quiet mode of operation in DAMISQL

ATIqa02211:

DDK: Support renaming of driver DLL during installation

ATIqa02235:

DDK: Support custom connect string in DAMISQL/OAISQL

ATIqa02236:

ODBC: Support custom connect dialgoue box

ATIqa02238:

DAM: Support improved conversions in damex_addResValToRow(), damex_addColValToRow()

ATIqa02239:

DDK: Support native .NET Data Provider

ATIqa02248:

SDK: Support nested transactions

ATIqa02252:

DAM: Support bracket delimited [identifier] in query

ATIqa02254:

DDK: Environment Variable Scipt in korn Shell on Unix

ATIqa02258:

DDK: Support evaluation key generation for end users

ATIqa02259:

JDBC: Support JDBC Connection Pooling from BEW WebLogic

ATIqa02269:

DAM: Index information should be used for deciding join order even if IP disables Index Optimization

ATIqa02273:

SDK: Allow writing IPs in JAVA

ATIqa02291:

SDK: Speed optimizations Win32 - NoParamValid, Optimize build flags, Inline

ATIqa02294:

JDBC: Support custom connect string

ATIqa02308:

OLEDB: Record set updatibility -- we need to be smarter about when we call OA_STAT in order to improve performance

ATIqa02316:

SDK: Upgrade to using Installshield 6 and simplify our IS stuff as much as possible

ATIqa02331:

RDA: Support length descriptors larger than 32767

ATIqa02332:

DAM: Support additional string scalar functions (SUBSTRING, CHAR_LENGTH..)

ATIqa02333:

SDK: Support 2k error message length

ATIqa02343:

DAM: Expose Table Correlation Name(Alias) to IP

ATIqa02349:

DAM: Allow Join Order Optimization based on Search Condition to be disabled

ATIqa02354:

JDBC: Support multiple results

ATIqa02365:

OLEDB: Performance improvement in distributed transaction

ATIqa02368:

DAM: Support conditional expression DECODE as supported by Oracle

ATIqa02373:

.NET: Support DataAdapter

ATIqa02379:

SDK: Support column attributes -- including Key or not, table name, base column name, schema, qualifier, etc

ATIqa02380:

SDK: Return additional column(s) in order to make rows in a rowset unique

ATIqa02388:

OLEDB: Prepare sample dialogue for Data Link to support DSNless connection

ATIqa02411:

SDK: Make the ODBC IP sample portable to UNIX

ATIqa02412:

DAM: Support + and - operators on DATE/TIMESTAMP fields to add/subtract number of days specified as a number (int, float)

ATIqa02415:

DAM: Support EXISTS and UNIQUE predicate

ATIqa02416:

DAM: Support Quantified Conditional predicates (SOME, ANY, ALL)

ATIqa02417:

DAM: Support Assignment Operator (=) for specifying alias name for a result column

ATIqa02418:

DAM: Support @@Variables of SQLServer in Passthrough mode

ATIqa02430:

DAM: Pushdown of Table Search Expression and Join Expression in standard IP mode

ATIqa02444:

DAM: Support combined usage of MAX_ROWS and QUERY_TIMEOUT options.

ATIqa02447:

DAM: Allow ":" in the table or column names

ATIqa02450:

DAM: Enhance the ODBC pass through sample to be configured to not push post processing to the IP

ATIqa02451:

SDK: Dummy ISAM layer to supply as template with ISAM SDK

ATIqa02459:

SDK: Limit active rows in the rowset.

ATIqa02461:

SDK: Windows based Rdaadmin

ATIqa02481:

DAM: Support nested subquery in FROM clause

ATIqa02515:

ODBC: Support SQLSetStmtOption(SQL_BIND_TYPE)

ATIqa02521:

JDBC: Support ISQL with JDBC API

ATIqa02527:

ODBC: Allow SQLCancel in local mode to call a function registered in the SQL IP

ATIqa02540:

SDK: SDK for JAVA with SQL IP

ATIqa02551:

ODBC: Allow customization of schema.owner to use for catalog queries (OA_TABLES, etc)

ATIqa02557:

SDK: Allow OpenRDA Server to be started with server key as an argument

ATIqa02564:

DAM: Static schema mode can consume DBF or binary format schema files

ATIqa02565:

DAM: Support binary schema in Static Schema mode

ATIqa02595:

DAM: Allow marking the entire condition lists of the subquery as evaluated

ATIqa02605:

ODBC: Support option to enable/disable QueryTimeout

ATIqa02608:

DAM: Optimize coun(*) processing. Mark only the first column of