Database Driver Enhancements in PowerBuilder 11.1

There are some database driver enhancements in version 11.1. If you are using Informix® 10, Oracle® 10g, or Sybase ASE® 15, read on:

Informix 10 Support:

•The I10 interface supports ANSI/DBCS and Unicode databases

•The I10 interface supports Informix long object names with up to 128 characters

•With IDS 9.2.1 and later, you can change the name of an index in the Database painter when you are connected using the I10 interface

•SQL Statement Caching is Supported

•Creating and dropping indexes without locking

•Column-level encryption is supported

•Using multiple OUT parameters in user-defined routines is supported

Oracle Driver Enhancements:

•Statement caching in Oracle 10g provides and manages a cache of statements for each session

•To set the maximum size of the statement cache, set the StatementCache DBParm to the number of statements you want to cache

–0 (Default) means caching is disabled

•This option is available only in the O10 database interface

Sybase ASE 15 Driver Enhancements:

•In Adaptive Server Enterprise 15.0 and later, you can use the following datatypes as identity columns:

–bigint, int, numeric, smallint, tinyint, unsigned bigint, unsigned int, and unsigned smallint

•This support has been added to both the ASE (introduced in 11.0) and SYC database interfaces