Overview
 
Overview
The PSQL online help library provides three areas of reference: general, advanced, and developer.
General Reference
General reference content is intended for all levels of users and cover such topics as using the database management system, configuring settings, and performing tasks with the PSQL utilities.
Book
Description
What’s New in PSQL
Documents the additions and updates to the current version of PSQL
Getting Started with PSQL
Documents installation of the PSQL database engine, client, and initial configuration
PSQL User's Guide
Documents PSQL utilities and common tasks
Status Codes and Messages
Documents the status codes and messages returned by the PSQL components
Advanced Reference
Advanced reference content is intended for users with strong technical backgrounds in data processing and related disciplines. This content allows users who are already familiar with PSQL to gain more in-depth information on how to use the product. Specialized tools, such as DDF Builder, and specialized IT infrastructure such as hypervisor environments are discussed in this section.
Book
Description
Advanced Operations Guide
Documents database and maintenance procedures for more experienced users
DDF Builder User's Guide
Explains the utility used to view, create, and change PSQL data dictionary files (DDFs)
Developer Reference
Developer reference books are intended for application developers. These guides support the creation of applications that use the Btrieve (transactional) interface, the relational interface, or a combination of the two. In addition, some access methods such as Delphi and C++ Builder and OLE DB provide APIs for both interfaces.
Overview of Programming Methods
Book
Description
PSQL Programmer's Guide
Explains the Btrieve (transactional) and relational interfaces from an application development perspective
Administrative Methods
Book
Description
Distributed Tuning Interface (DTI) Guide
Explains interface for configuration, monitoring, and diagnostics of PSQL components
Distributed Tuning Object (DTO) Guide
Explains the COM wrapper for DTI
Installation Toolkit Handbook
Explains how to integrate a PSQL product installation with another application installation
Database Access Methods
Access Method
Document
Description
Btrieve API
Btrieve API Guide
Explains how to use the Btrieve API for transactional applications
SQL
SQL Engine Reference
Covers the query language syntax, functionality, and limitations of the PSQL relational engine
ODBC
ODBC Guide
Documents the ODBC API conformance
ADO.NET
Data Provider for .NET Reference
Explains how to use ADO.NET with PSQL
Java Database Connectivity (JDBC)
JDBC Driver Guide
Explains how to use JDBC with PSQL
Java Persistence API (JPA)
JPA Overview
Explains how to use PSQL as an EclipseLink JPA platform
Java
Java Class Library Guide
Documents classes for the PSQL Java interface
Delphi and C++ Builder (PDAC)
PSQL Direct Access Components (PDAC) Guide
Explains the set of components that allow direct access to PSQL data from the Delphi and C++ Builder environments
OLE DB
OLE DB Provider Guide
Covers the PSQL implementation of the OLEDB Provider Specification, including ADO
ActiveX
ActiveX Control's Guide
Explains the set of custom controls that enable ActiveX environments to access PSQL data
Third-party Methods and Solutions
For PSQL developer-related white papers, sample code, components, and up-to-date news, see the PSQL website.
Contacting Actian Corporation
Visit the PSQL support services website for PSQL support information, company contact information, and if you have product questions or comments to post on the Community Forum.
© Copyright Actian Corporation. All Rights Reserved.