API Programmer's Reference - Table of Contents

Pervasive.SQL 8.7 (code API_870, revision 1)  Sync manual in Pervasive Library

About This Manual

Where to Get Information

Who Should Read This Manual

Manual Organization

Conventions

Overview of Pervasive APIs and Interfaces

Overview of APIs

Other Programming Methods

Transactional Programming with Btrieve

Introduction to Btrieve APIs

Btrieve Functions

BTRV Function

BTRVID Function

BTRCALL Function

BTRCALL32 Function

BTRCALLID Function

BTRCALLID32 Function

Obsolete Functions

Btrieve Function Parameters

Operation Code

Status Code

Position Block

Data Buffer

Data Buffer Length

Key Buffer

Key Number

Client ID

Key Length

Summary of Btrieve Operations

Session-Specific Operations

File-Specific Operations

Unsupported Operations

Sequence of Events in Performing a Btrieve Operation

Btrieve Operations

Abort Transaction (21)

Begin Transaction (19 or 1019)

Clear Owner (30)

Close (1)

Continuous Operation (42)

Create (14)

Create Index (31)

Delete (4)

Drop Index (32)

End Transaction (20)

Find Percentage (45)

Get By Percentage (44)

Get Direct/Chunk (23)

Get Direct/Record (23)

Get Directory (18)

Get Equal (5)

Get First (12)

Get Greater (8)

Get Greater Than or Equal (9)

Get Key (+50)

Get Last (13)

Get Less Than (10)

Get Less Than or Equal (11)

Get Next (6)

Get Next Extended (36)

Get Position (22)

Get Previous (7)

Get Previous Extended (37)

Insert (2)

Insert Extended (40)

Login/Logout (78)

Open (0)

Reset (28)

Set Directory (17)

Set Owner (29)

Stat (15)

Stat Extended (65)

Step First (33)

Step Last (34)

Step Next (24)

Step Next Extended (38)

Step Previous (35)

Step Previous Extended (39)

Stop (25)

Unlock (27)

Update (3)

Update Chunk (53)

Version (26)

Java Interface Reference

How to find Online Java Reference Information

Conceptual Information

Reference Information

SQL Programming

ODBC API Reference

Where to Find Information on the Pervasive ODBC Driver

Other SQL Access Methods

JDBC API Reference

JDBC API Reference

JDBC Samples

Distributed Tuning Interface

Distributed Tuning Interface Guide

Overview of Pervasive Distributed Tuning Interface

Monitoring and Diagnostics

Configuration

Catalog

How to Use the Distributed Tuning Interface

Header Files

Before Calling Any Functions

Sample Programs For the Distributed Tuning Interface

Common Procedures Using DTI

Making a Connection to a Server using DTI

Obtaining a Setting ID using DTI

Passing a DTI Structure as a Parameter

Distributed Tuning Interface Reference

How to use this chapter

Functional Groups

Error Messages

Structures in DTI

CONFIG.H Structures

DDF.H Structures

MONITOR.H Structures

Calling Sequence

DTI Function Definitions

PvAddIndex()

PvAddLicense()

PvAddTable()

PvCheckDbInfo()

PvCloseDatabase()

PvCloseDictionary()

PvConnectServer()

PvCopyDatabase()

PvCountDSNs()

PvCountSelectionItems()

PvCreateDatabase()

PvCreateDictionary()

PvCreateDSN()

PvDeleteDSN()

PvDeleteLicense()

PvDisconnect()

PvDisconnectMkdeClient()

PvDisconnectSQLConnection()

PvDropDatabase()

PvDropIndex()

PvDropIndexByName()

PvDropTable()

PvFreeDbNamesData()

PvFreeMkdeClientsData()

PvFreeOpenFilesData()

PvFreeSQLConnectionsData()

PvFreeTable()

PvFreeTableNames()

PvGetAllPossibleSelections()

PvGetBooleanStrings()

PvGetBooleanValue()

PvGetCategoryInfo()

PvGetCategoryList()

PvGetCategoryListCount()

PvGetDbDataPath()

PvGetDbDictionaryPath()

PvGetDbFlags()

PvGetDbName()

PvGetDbNamesData()

PvGetDbServerName()

PvGetDSN()

PvGetDSNEx()

PvGetEngineInformation()

PvGetError()

PvGetFileHandlesData()

PvGetFileHandleInfo()

PvGetFileInfo()

PvGetLicenses()

PvGetLongValue()

PvGetMkdeClientId()

PvGetMkdeClientInfo()

PvGetMkdeClientHandlesData()

PvGetMkdeClientHandleInfo()

PvGetMkdeClientsData()

PvGetMkdeCommStat()

PvGetMkdeCommStatEx()

PvGetMkdeUsage()

PvGetMkdeUsageEx()

PvGetMkdeVersion()

PvGetOpenFilesData()

PvGetOpenFileName()

PvGetSelectionString()

PvGetSelectionStringSize()

PvGetSelectionValue()

PvGetServerName()

PvGetSettingHelp()

PvGetSettingHelpSize()

PvGetSettingInfo()

PvGetSettingList()

PvGetSettingListCount()

PvGetSettingMap()

PvGetSettingUnits()

PvGetSettingUnitsSize()

PvGetSQLConnectionsData()

PvGetSQLConnectionInfo()

PvGetStringType()

PvGetStringValue()

PvGetStringValueSize()

PvGetTable()

PvGetTableNames()

PvGetValueLimit()

PvIsSettingAvailable()

PvListDSNs()

PvModifyDatabase()

PvModifyDSN()

PvOpenDatabase()

PvOpenDictionary()

PvSetBooleanValue()

PvSetLongValue()

PvSetSelectionValue()

PvSetStringValue()

PvStart()

PvStop()

Appendixes

Data Types

Where to Find Data Types Information

Quick Reference of Btrieve Operations

Table of Btrieve Operations