Welcome to PSQL v12

Welcome to PSQL v12

The online help library is divided into three areas: general reference, advanced reference, and developer reference.

General Reference

The 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

The 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 infrastructures, 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

These reference books are intended for application developers and other advanced users. The content enables developers to create applications using either the Btrieve (transactional) interface, the relational interface, or a combination of the two. In addition, some access method such as Delphi and C++ Builder and OLE DB provide API sets 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.