OpenAccess SDK 5.0 (January 2003)

ATIqa00900:

DDK: Support COMMIT, ROLLBACK & AUTOCOMMIT commands from ISQL

ATIqa01049:

JDBC: Porting JDBC SDK on Linux

ATIqa01507:

DAM: Support Block Joins

ATIqa01508:

DAM: Support detection of condition that 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 dialogue 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 updatability -- 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 each table(s) as used in RESULT

ATIqa00229:

DDK: fopen() calls should explicitly specify the mode (text or binary)

ATIqa00350:

ODBC: SQLDriverConnect does not prompt for DATABASE if it is not specified

ATIqa00405:

DAM: MAX function returns junk in some cases and NULL in others

ATIqa00488:

DAM: Search expressions with non-constant Scalar Functions are not used for query optimization on individual tables

ATIqa00649:

ODBC: Allow login dialog customization of ODBC driver (client & server)

ATIqa00791:

RDA: Server is disconnected if LONGVARBINARY width is more than 0x7FFF.

ATIqa00975:

RDA: getResultCol() generates truncation warning when called from SQLGetData()

ATIqa01074:

DAM: Large numeric literals in query string not handled correctly

ATIqa01191:

DAM: Error with DISTINCT when query has set functions or group by

ATIqa01742:

DAM: Crash with Numeric data when added has empty string

ATIqa01789:

JDBC: Fix Appletviewer problem with JDK 1.3.1

ATIqa01796:

SDK: We do not allow CURSOR after COMMIT behavior to be modified

ATIqa01797:

ODBC: Describe param is not working properly

ATIqa01799:

DDK: XM module should be used by all platform

ATIqa01863:

DDK: SQLGetOption should return null terminated string

ATIqa01886:

ODBC: SQLDriverConnect output string is skipping user defined connect option.

ATIqa01888:

ODBC: RESPONSE_TIME_OUT in the client side is limited to a short signed integer ~ 9.1 hours

ATIqa01958:

SDK: Include patch number in the release version

ATIqa01990:

DAM: Optimize aggregate computation when IP handled GROUP BY

ATIqa02166:

DDK: Change build media of ODBC driver from diskette to CD-ROM.

ATIqa02167:

DDK: Problem in returning DOUBLE & REAL values as strings

ATIqa02173:

DDK: Put line# in ODBC/OLE DB tracing

ATIqa02174:

ODBC: SQLGetData with SQL_C_BINARY to VARCHAR conversion fails

ATIqa02186:

DDK: Make trace unlimited when full trace is ON

ATIqa02188:

DAM: Modify source for dam_getIno(IP_MCI_FILTER_DEFAULT)

ATIqa02190:

OLEDB: Schema memory leaks during ADO client side cursor

ATIqa02197:

DAM: DAM error out for sort field id greater than 127

ATIqa02202:

RDA: RDAADMIN crash if environment variables not found

ATIqa02203:

JDBC: Remove temporary allocation in Date, Time & TimeStamp field

ATIqa02204:

DAM: Apply case-insensitive preference of a column for LIKE operations on that column

ATIqa02206:

DAM: DAM_INFO_STRCMP_FUNC not called when expected

ATIqa02209:

DDK: Crash in the server during codebase access from multiple users at the same time

ATIqa02210:

DAM: Make DAM thread safe/fully threaded to work in multithreaded environment

ATIqa02212:

DDK: Remove odbc folder from the installation

ATIqa02214:

JDBC: SQLException should return SQL error to application

ATIqa02215:

DDK: Add prototypes to SQL IP interface - Regular SDK

ATIqa02216:

DDK: ODBCISQL is not handling WCHAR data correctly

ATIqa02219:

DDK: Server crash during INSERT if value is NULL data for NUMERIC data type

ATIqa02222:

OLEDB: Update fail for quoted table name

ATIqa02224:

DDK: Remove warning: issperr.h is an obsolete header file

ATIqa02225:

DAM: Select TOP N option not working correctly

ATIqa02227:

DAM: Problem handling simple expressions in search condition of Join queries

ATIqa02230:

DDK: Select query with set functions and literal select expression crashes on empty results

ATIqa02231:

DAM: Trace IP function calls

ATIqa02232:

DAM: Allow dam_getSetOfConditionListsEx to be used in Pushdown join processing

ATIqa02237:

OLEDB: Modify UPDATE command for WCHAR to prefix with N

ATIqa02240:

DDK: Redundant server controlled by IP with two IP addresses is not working

ATIqa02241:

OLEDB: Error during RestartPosition with parametric command

ATIqa02242:

OLEDB: Crash if application is not providing parameter values

ATIqa02244:

DAM: LIKE predicate not supported on Variant type

ATIqa02247:

OLEDB: ADO application crash during retrieving zero length LONGVARCHAR data

ATIqa02249:

OLEDB: Optimize RestartPoistion implementation

ATIqa02250:

SDK: Pass command to SQL IP server without looking for SELECT/parameters

ATIqa02251:

DAM: Validate date and time values in query

ATIqa02257:

SDK: Having OA not parsing request string at all and using get_numcols() to determine if open_cursor() must be called.

ATIqa02270:

OLEDB: Change TYpeName in ProviderTypes schema

ATIqa02271:

OLEDB: Build OLE DB using ATL include files from VOBS instead of VC++ ATL\include

ATIqa02278:

DAM: Views report syntax error when base table or columns require quoted identifiers

ATIqa02279:

JDBC: Problem with Visual Cafe

ATIqa02280:

DAM: Divide by 0 of Numeric type field is causing exception

ATIqa02281:

ODBC: If openrda.ini or oadrd.ini files are readonly, updating these files using rdaadmin doesn't gives any error.

ATIqa02282:

ODBC: Parameter values concated in specific application sequence

ATIqa02284:

SDK: Logging should include the Operating system the log was generated on

ATIqa02285:

SDK: Logging should include time stamps.

ATIqa02295:

DAM: Modify SQLQueue to support inline functions

ATIqa02307:

DAM: Damisql ignores the query string following the -q

ATIqa02318:

SDK: Problem Linking with noodbcdrv.obj

ATIqa02319:

ODBC: SQLDescribeCol does not always return null terminated column name.

ATIqa02321:

DAM: ip_getSupport passes ip_hdbc after connection

ATIqa02322:

SDK: OPENRDA.INI Search Order

ATIqa02323:

RDA: RowCount value larger than 32767 is not supported

ATIqa02325:

ODBC: DSNless connection report SQLMoreResult not supported

ATIqa02327:

RDA: Define Sint16, Sint32 as "int" and Uint16 and Uint32 as "unsigned int" on Win32

ATIqa02328:

DB Server: Insert of large Blobs from Unix clients crashes the server

ATIqa02329:

ODBC: ODBC driver is not supporting AutoCommit when query is executed using DATA_AT_EXEC parameters

ATIqa02330:

DAM: NULL parameter data not handled correctly

ATIqa02335:

DAM: Subquery in value list of the IN predicate is not handled correctly

ATIqa02341:

SDK: We don't support CHAR/VARCHAR to integer conversion in GetData/BindCol

ATIqa02342:

DAM: Constant scalar function used in join queries are not being pre-computed

ATIqa02344:

DAM: Transforming INNER Join into old WHERE style Join causes problem

ATIqa02351:

SDK: Crash occurred in parallel execution of statements on different thread on same connection

ATIqa02352:

DAM: SELECT *, select-item FROM table-list - reports syntax error

ATIqa02353:

DAM: Make CALL keyword and Parenthesis around argument list optional in Stored Procedure command

ATIqa02355:

DAM: Codebase memory leak of 568 bytes in codebase.51\source\m4memory.c(653)

ATIqa02356:

OLEDB: DBTYPE_DATE parameterized fields problem

ATIqa02357:

ODBC: Install Shield 6.x errors out for CreateFile() function

ATIqa02360:

DAM: Correlated subquery is not being exposed correctly in Passthrough API

ATIqa02362:

DAM: Expose TOP N PERCENT Select Clause in Passthrough API

ATIqa02363:

ODBC: SQLSetStmt option trace problem

ATIqa02364:

DAM: Views are not supported in Passthrough mode

ATIqa02366:

OLEDB: INSERT Parameter value problem when DBPART_LENGTH is specified and value is not null terminated

ATIqa02369:

OLEDB: .NET Server Explorer only showing last column

ATIqa02370:

DAM: CREATE TABLE - Support column constraint NULL

ATIqa02376:

SDK: RDA statement length is limited to 8192 -- increase to match SQL statement length in other layers

ATIqa02377:

SDK: SQLExecDirect and data at exec not supported

ATIqa02378:

ODBC: LD_LIBRARY_PATH is overwritten when we run the setenv.sh script on the unix platforms

ATIqa02385:

OLEDB: Parametric command execution problem

ATIqa02387:

SDK: Disable cursor based processing if query timeout is set

ATIqa02389:

DAM: Conversion errors during query validation are not being reported correctly

ATIqa02390:

ODBC: SQLDecribeCol with null passed in for fSqlType causes crash when ODBC trace on

ATIqa02391:

ODBC: ODBC tracing -- SQLColAttribute(SQL_COLUMN_AUTO_INCREMENT) with invalid pointer in pcbDesc causes bus error

ATIqa02393:

DAM: Errors reported from IP stored procedure execution are not being reported

ATIqa02395:

OLEDB: GetParamInfo return error when SetParamInfo does not supply parameter info

ATIqa02397:

SDK: OpenRDA Server on NT does not exit when Ctrl-C is hit if SessPollWait is set to -1

ATIqa02398:

SDK: Local SDK for JAVA hangs with JDK 1.4

ATIqa02399:

SDK: Problem in nested transaction

ATIqa02402:

DAM: Search patterns in Catalog Functions arguments not handled correctly

ATIqa02403:

ODBC: Making attribute-keywords in connection string case insensitive

ATIqa02404:

SDK: Large value of RESPONSE_TIME_OUT generates low level connection error

ATIqa02407:

SDK: Bug in disk cache processing logic when query time out in in affect

ATIqa02409:

DAM: Scalar function registration is optional in passthrough mode

ATIqa02413:

SDK: Default session poll wait time should be changed from 10 seconds to a larger number

ATIqa02414:

OLEDB: SetParameterInfo calls multiple time to provide parameters info for a command

ATIqa02420:

DAM: Problem in flushing disk cache file when query timeout occurs

ATIqa02423:

SDK: Parameter crash problem

ATIqa02429:

DAM: Outer Join SubQueries in FROM clause are not working

ATIqa02431:

SDK: Behavior change (bug) in Open Access SDK 4.80.26 versus 4.80.16

ATIqa02432:

ODBC: STMT_OPTIONS for MAX_ROWS and QUERY_TIMEOUT are being ignored in Prepare/Execute sequence Build SDK 4.80.26

ATIqa02434:

SDK: Client crash during CHAR to VARCHAR conversion for an empty string parameter

ATIqa02435:

OLEDB: oainfo.ini was readonly after the OLE DB installation

ATIqa02436:

DAM: SubQueries (having scalar functions) in FROM clause are not working

ATIqa02437:

DAM: SubQueries (that contain NULL literals) in FROM clause are not working

ATIqa02438:

SDK: How to determine client connection type

ATIqa02441:

DAM: Outer Join queries - Search conditions in WHERE clause is not being processed correctly

ATIqa02442:

OLEDB: Empty schema name with linked server query is not working

ATIqa02443:

DAM: Expressions in select-list of View queries and Queries using SubQuery in FROM clause not being handled correctly

ATIqa02445:

DAM: Changes in call to ip_support() interface

ATIqa02446:

OLEDB: Parametric BLOB of less than 2048 size is crashing

ATIqa02454:

DAM: Problems with Set functions in Pass through mode when post-processing is not handled by IP

ATIqa02455:

OLEDB: Linked server is not passing DATETIME filter to the provider.

ATIqa02456:

ODBC: Problem with error reporting when no error message is added by DAM/IP

ATIqa02460:

ODBC: Customizing error messages prefix

ATIqa02462:

SDK: rdaadmin is not synchronized with openrda.ini

ATIqa02467:

DAM: Outer joins with IS NULL condition in WHERE clause not handled correctly

ATIqa02469:

OLEDB: Connection pooling problem

ATIqa02470:

OLEDB: Mapped SQL State to appropriate OLE DB error

ATIqa02471:

DAM: OR expressions in Join queries should be handled more efficiently

ATIqa02472:

DAM: GROUP BY clause with no set functions in select-list is not eliminating duplicates

ATIqa02475:

ODBC: OpenRDA ODBC does not work with JDK 1.3.x JDBC to ODBC bridge

ATIqa02476:

SDK: If openrda.ini is missing we gets a License Error

ATIqa02480:

SDK: Control C does not call ip_exit

ATIqa02482:

OLEDB: Problem with DBTYPE_NUMERIC parameter

ATIqa02483:

ODBC: SQLTables() is not supporting enumeration of catalogs, schema and table types

ATIqa02494:

OLEDB: Rowset viewer prepare the statement twice

ATIqa02497:

OLEDB: Registry problem for DataLink GUID on Windows 2000

ATIqa02499:

SDK: If we try to edit a existing database entry using rdaadmin it forces to enter all the mandatory values again

ATIqa02500:

SDK: Remove the need to look at a SQL statement on the client to see if it is a CALL or a SELECT

ATIqa02501:

RDA: Session layer indefinitely keeps polling on a socket and fills up log file

ATIqa02502:

ODBC: In 5.0 enable SQLDescribeParam by default

ATIqa02503:

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

ATIqa02508:

SDK: rdaadmin edit database entry problem

ATIqa02510:

OLEDB: Procedure Column schema changes

ATIqa02520:

SDK: OAISQL needs to set correct connect options to reflect the version it is being built for

ATIqa02525:

SDK: ISAM IP -- optimize order by clauses if the ordering is on indexed column that is already in the right order

ATIqa02532:

OLEDB: new client is not compatible with old server

ATIqa02536:

ODBC: Application specific behavior for SQLSetStmtOption(ROWSET_SIZE)

ATIqa02537:

SDK: Error at SQLS layer not cleared -- next statement execution sate is misleading.

ATIqa02538:

OLEDB: Server explorer of VC.NET is not working

ATIqa02549:

OLEDB: GetPropertyInfo crashes the application

ATIqa02550:

ODBC: SQLStatistics information for SQL_TABLE_STAT does not return NON_UNIQUE as a NULL

ATIqa02552:

OLEDB: Datatype rowset must return VARIANT

ATIqa02553:

DAM: Custom error for nested transaction is not propagated

ATIqa02554:

ODBC: SQLColumns returns zero records

ATIqa02555:

SDK: Problem with IP JAVA object connecting to JNDI

ATIqa02556:

SDK: Change default SessPollWait time to 60 seconds

ATIqa02569:

JDBC: PrepareStatment object failed with JAVA server

ATIqa02571:

ODBC: Use of base column name instead of alias name in ORDER BY from SQLSpecialColumns fails on a ISVs SQL engine

ATIqa02579:

ODBC: Error getting results from stored procedure with multiple results when result size > FETCH_BLOCK_SIZE

ATIqa02583:

SDK: ISAM IP - does not correctly report a missing conversion function

ATIqa02586:

ODBC: SQLBrowseConnect shouldn't return error if output buffer is NULL

ATIqa02588:

DAM: dam_addValToRow() - problem when non-char data (Numeric, Integer) is added as a non-NTS string

ATIqa02590:

ODBC: Repeated execution of query with NULL parameter data in later execution causes crash

ATIqa02591:

DAM: dam_getSetOfConditionListsEx() crashes with UNION Condition lists on a correlated subquery

ATIqa02593:

JDBC: wasNull is not working for Numeric datatypes

ATIqa02599:

ODBC: QueryTimeout used by MSAccess causes problem for schema lookup that takes long

ATIqa02600:

RDA: Server is not using the FETCH_BLOCKSIZE setting passed by Client

ATIqa02604:

DAM: Divide by zero error reported for any numeric operation with value 0.

ATIqa02607:

SDK: Example2 handle assumes single connection

ATIqa02612:

ODBC: Behavior change for SQLFetch

ATIqa02613:

JDBC: getTables() function call crash

ATIqa02620:

DAM: Table Statistics information requires seq_in_index to be set to 1