Pervasive PSQL v9 DTI Interface - May 2006

This document contains the following topics:

About the DTI Interface
Features
System Requirements
Getting Started
- Installation
- Components List
Known Issues
Useful Links
Disclaimer

About the DTI Interface

This release contains documentation, samples, and components related to the Pervasive PSQL Distributed Tuning Interface.

New Features

See What's New in Pervasive PSQL v9 and DTI Guide for documentation on the DTI interface.

Pervasive PSQL v9 SP2 (9.5)

A new API PvGetTableStat() that returns statistical information on a given table was added for the Pervasive PSQL v9 release but not mentioned in the last readme. For complete information, see the DTI Guide.

Pervasive.SQL V8 (8.5)

The following features were added for the v8.5 release.

New Flags for Security

The flags allow you to specify a security model when creating or modifying a database, and to allow you to query the security model of an existing database. The changes take the form of new database flags and affect the following functions:

PvCreateDatabase()
PvModifyDatabase()
PvGetDbFlags

The new database flags for these functions are:

Flag Hex Meaning

P_DBFLAG_DBSEC_AUTHENTICATION 0x00000008 Database Security Authentication

P_DBFLAG_DBSEC_AUTHORIZATION 0x00000010 Database Security Authorization

Flag	Hex	Meaning
P_DBFLAG_DBSEC_AUTHENTICATION	0x00000008	Database Security Authentication
P_DBFLAG_DBSEC_AUTHORIZATION	0x00000010	Database Security Authorization

The following table indicates how to specify a security model in a new database, or to interpret the security model of an existing database.

This Flag Combination	Represents this Security Model
No flags	Classic
P_DBFLAG_DBSEC_AUTHENTICATION	Mixed
P_DBFLAG_DBSEC_AUTHENTICATION + P_DBFLAG_DBSEC_AUTHORIZATION	Database

Pervasive.SQL V8 (8.0)

The following features were added for the v8.0 release:

License Management functions: PvAddLicense(), PvDeleteLicense()
Engine Version: PvGetMkdeVersion()
Monitor Auto Reconnect feature: PvGetMkdeCommStatEx()

System Requirements

Existing install of Pervasive PSQL v9 Engine

Getting Started

Installation

There is no separate install for the DTI interface. The DTI runtime binaries listed under the Components List are installed by the PSQL engine installation. PSQL v9 SP2 DTI SDK is available for download at: http://www.pervasive.com/developerzone/access_methods/dtidto.asp

Components List

The following components are included. The directory locations assume you installed the SDK to c:\pvsw\sdk.

Component Description

c:\pvsw\sdk\dti\intf\*.* DTI header files for C and import libraries

c:\pvsw\sdk\dti\samples\msvc\ DTI sample for MS Visual C++, Delphi

c:\pvsw\sdk\dti\samples\delphi5\ DTI sample for Delphi

c:\pvsw\sdk\dti\doc\ Documentation for the Distributed Tuning Interface

Component	Description
c:\pvsw\sdk\dti\intf\.	DTI header files for C and import libraries
c:\pvsw\sdk\dti\samples\msvc\	DTI sample for MS Visual C++, Delphi
c:\pvsw\sdk\dti\samples\delphi5\	DTI sample for Delphi
c:\pvsw\sdk\dti\doc\	Documentation for the Distributed Tuning Interface

Known Issues in this release

The following are known issues with this release.

Issue Number	Description
51213	If you delete a SQL table using SQL you can't recreate the same table via DTI using cobolschemaexec without restarting the Pervasive PSQL engine.
53413	In Linux, DTI allows invalid characters in database names.
53564	DTI PvListDSNs() API returns an incorrect error code: P_E_NULL_PTR instead of P_E_BUFFER_TOO_SMALL when buffer size is 0.
53501	Unable to create a database with create dictionary files unchecked. Unable to create a bound database if create dictionary files option is not specified and no DDF files are present in the dictionary location.

Useful Links

Discuss all your Pervasive development issues at DevTalk at http://www.pervasive.com/devtalk.

See some creative applications and code snippets and share your own at Pervasive ComponentZone at http://www.pervasive.com/componentzone.

Disclaimer

PERVASIVE SOFTWARE INC. LICENSES THE SOFTWARE AND DOCUMENTATION PRODUCT TO YOU OR YOUR COMPANY SOLELY ON AN "AS IS" BASIS AND SOLELY IN ACCORDANCE WITH THE TERMS AND CONDITIONS OF THE ACCOMPANYING LICENSE AGREEMENT.
PERVASIVE SOFTWARE INC. MAKES NO OTHER WARRANTIES WHATSOEVER, EITHER EXPRESS OR IMPLIED, REGARDING THE SOFTWARE OR THE CONTENT OF THE DOCUMENTATION; PERVASIVE SOFTWARE INC. HEREBY EXPRESSLY STATES AND YOU OR YOUR COMPANY ACKNOWLEDGES THAT PERVASIVE SOFTWARE INC. DOES NOT MAKE ANY WARRANTIES, INCLUDING, FOR EXAMPLE, WITH RESPECT TO MERCHANTABILITY, TITLE, OR FITNESS FOR ANY PARTICULAR PURPOSE OR ARISING FROM COURSE OF DEALING OR USAGE OF TRADE, AMONG OTHERS.