PreviousWhat's New in Pervasive PSQL v10 (v10) Next

Access Methods (Software Development Kit)

Chapter contents

This release of Pervasive PSQL includes changes to the following programming access methods:

Also note that the runtime components for all access methods can now be installed with the database engine or client. See Data Access Components .

Btrieve API

The 32-bit import library for the Btrieve API has been compiled with Microsoft Visual Studio 2005. The Btrieve API includes support for 64-bit applications and page compression. See the following:

Distributed Tuning Interface (DTI)

The DTI 32-bit import library has been compiled with Microsoft Visual Studio 2005. DTI includes support for 64-bit applications, metadata versions, page compression, partial indexes, and user and group management. See the following:

Partial Indexes

New flags have been added to the INDEXMAP structure to support partial indexes. See Partial Indexes in this guide and DDFSTRCT.H Structures in the Distributed Tuning Interface Guide.

INDEXMAP Flags
B_FLAG_DUPLICATES = 1 

Duplicates allowed in index.

B_FLAG_MODIFIABLE = 2 

Index is modifiable.

B_FLAG_SORT_DESCENDING = 64 

Sort index descending.

B_FLAG_PARTIAL = 512 

Index is partial. Partial Index flags on segments that are not the last segment in the index are ignored. Partial Indexes only apply to the last segment in an index.

User and Group Management

New APIs exist to manage users and group. See the following in Distributed Tuning Interface Guide:

Distributed Tuning Objects

Distributed Tuning Objects includes support for metadata versions and partial indexes.

Metadata Versions

Database Flag contains a new enumeration to support V2 metadata.

Enumeration
Value
32
dtoDFlagLONGMETADATA

Partial Indexes

In the DtoIndex object, only the last column in an index segment can have a partial index flag. Index segments that are not the last segment in the index and that use the partial index flag ignore the partial flag.

The Index Flag contains a new enumeration for partial index.

Enumeration
Value
512
dtoIndexPartial

JDBC

The JDBC driver is a pure Java application. No dynamic link library is required if you connect to the database engine using sockets.

The DLL, pvjdbc2.dll, is required only if you connect using shared memory or IPX.

JDBC supports V2 metadata. See Metadata Versions .

OLE DB

OLE DB supports V2 metadata. See Metadata Versions .


Chapter contents
Book contents

Prev topic: Page Compression
Next topic: File Format and Page Size