The Powersoft ODBC interface has been enhanced for improved performance, clustered indexes, and additional connection options.

Performance enhancements

The Powersoft ODBC interface now includes blocked fetch support.  Blocked fetch support is dependent on the capability of the ODBC driver being used to make the database connection.

The maximum blocking factors available in PowerBuilder 5.0 are:

• 100 for a table list
• 25 for a column list
• 10 for an index list

Index support

Clustered options for indexes are supported in PowerBuilder 5.0, dependent on the entry in the PBODB050.INI file.

Connection options

PowerBuilder 5.0 now supports the following SQLServer ODBC connect options:

 

Option	Value
SQL_INTEGRATED_SECURITY	SQL_IS_OFF SQL_IS_ON
SQL_USE_PROCEDURES_FOR_PREPARE	SQL_UP_OFF SQL_UP_ON SQL_UP_DROP
SQL_PRESERVE_CURSORS	SQL_PC_OFF SQL_PC_ON