Login Register Actian.com  

Actian Community Blogs

Old

DBMS Server Enhancements Targeted for 10.1

Posted 2012-04-04 at 09:40 AM by teresa

The Ingres DBMS Server continues to move forward. The following highlights some of the most significant DBMS Server enhancements targeted for 10.1:
  • Common Table Expressions
  • Multi-row INSERT
  • New Location for Log Files on Windows
  • Inclusion of Process ID and Date in Log File Names
  • II_DATE_FORMAT Settings ISO4T and ISO4TC
  • UCS_BASIC Collation for Columns
  • Session level COLLATION

For more detail on the features, see the Ingres 10.1 Roadmap.

A number of the...
Ingres
Posted in Ingres
Views 153 Comments 0 teresa is offline Edit Tags
Old

Supportability & Usability Enhancements Targeted for 10.1

Posted 2012-04-04 at 09:28 AM by teresa
Updated 2012-04-04 at 09:41 AM by teresa

Improvements are continually being made to Ingres to improve both supportability and usability of the product. The following features are targeted for the 10.1 release:
  • Unicode-enabled Database by Default
  • Portable UTF-8-encoded Copydb and Unloaddb
  • Date Format with Space Delimiter
  • Support For DROP TABLE IF EXISTS
  • Identification of Long Running Queries

For more detail on the features, see the Ingres 10.1 Roadmap.

A number of the Ingres 10.1 features listed above...
Ingres
Posted in Ingres
Views 153 Comments 0 teresa is offline Edit Tags
Old

Connectivity Enhancements Targeted for Ingres 10.1

Posted 2012-04-03 at 09:03 AM by teresa
Updated 2012-04-04 at 09:41 AM by teresa
Tags .net, ingres, jdbc, odbc

Ingres Connectivity continues to evolve. The following enhancements are planned for Ingres 10.1:
  • ODBC Batch Execution – Execution of a single query with arrays of parameters
  • JDBC getGeneratedKeys Enhancement
  • .NET Data Provider support for Connection string Identifier_Delimiter = Bracket to allow the provider to recognize both double quotes and brackets for delimited identifiers
  • .NET Data Provider support for batch updates via the DbDataAdapter.UpdateBatchSize property

For more...
Ingres
Posted in Java, ODBC, .NET, Ingres
Views 159 Comments 0 teresa is offline Edit Tags
Old

Connectivity Enhancements in Ingres 9.3.x and 10.x

Posted 2012-04-03 at 08:56 AM by teresa

Many of you are just beginning to consider migrating from Ingres 9.2 and earlier releases and may be unaware of the many new features included in the Ingres Connectivity area since 9.2. I will be writing a series of blogs that details the changes in the protocol drivers, JDBC, ODBC, .NET, and OpenAPI since Ingres 9.2. These features are also applicable to Vectorwise unless otherwise noted.

Conclusion...
Ingres
Posted in Java, ODBC, .NET, Ingres
Views 128 Comments 0 teresa is offline Edit Tags
Old

ODBC Enhancements in Ingres 9.3.x and 10.0.x

Posted 2012-04-03 at 08:46 AM by teresa

Beginning with ODBC driver version number 3.50.930.0099, the ODBC driver was enhanced to support the DBMS scrollable cursor functionality introduced in Ingres 9.2. For more information, see the Connectivity Guide.

Ingres 9.3.1 introduced a performance improvement to the ODBC driver beginning with version 3.50.xxxx.0110, where xxxx is 930, 1000, or 1010. In certain scenarios, the chatter between the ODBC driver and the DBMS was significantly reduced, resulting in performance gains...
Ingres
Posted in ODBC, Ingres
Views 107 Comments 0 teresa is offline Edit Tags
© 2011 Actian Corporation. All Rights Reserved