User's Guide - Table of Contents

Pervasive PSQL v9 SP2 (9.5) (code USR_950, revision 1)  Books in this release

About This Manual

Who Should Read This Manual

Manual Organization

Conventions

Introducing Pervasive PSQL

Understanding the Pervasive PSQL Database Management System

What is a Database?

What is a Database Management System?

Components of Pervasive PSQL

Key Concepts

Basic Database Structures and Terms

Unique Benefits of Pervasive PSQL

Why Pervasive PSQL?

Understanding the DBMS Products

Workgroup

Server

Crystal Reports for Pervasive PSQL

Helpful Utilities

Using Pervasive PSQL Documentation

Getting Started Guides

What's New

User's Guide

Advanced Operations Guide

SQL Engine Reference

Status Codes and Messages

Pervasive Products and Services

Additional Information

File System Security

Using Pervasive PSQL

Starting and Stopping the Database Engine

Starting and Stopping the Server Engine on a Windows Server

Starting and Stopping the Workgroup Engine on Windows

Starting and Stopping the Database Engine on NetWare

Starting and Stopping the Database Engine on Linux

Granting Administrative Rights for the Database Engine

Tasks Requiring Administrative Rights

How Administrative Rights are Granted

Rights Within an Active Directory Environment

Rights Provided to non-Administrative Users

Tasks for Granting Administrative Rights

Granting Administrative Rights on a Windows Server

Granting Administrator Rights on NetWare 4.2, 5.x or 6.x

Granting Administrator Rights on Linux

Logging in as Administrator on any platform

Setting Up ODBC Database Access

Basic Concepts

Setting up Database Access with PCC

Setting Up Database Access on Windows

Setting Up Database Access on a NetWare Server

Setting Up Database Access on a Linux Server

Setting Up Client Access

Accessing Data via ODBC From Other Applications

Before You Begin

Accessing Data Using Microsoft Excel

Accessing Data Using Microsoft Access

Deleting DSNs

Using the Fast User Switching Feature of Windows XP

Using Pervasive PSQL Control Center

An Overview of Pervasive PSQL Control Center

Installing PCC

Starting PCC

Editors and Windows Views Within PCC

Preferences

Additional Utilities

External Tools

Services on Windows Servers

Services Properties

Database Engines

Database Engine Properties

Databases

Database Properties

Tables

Data Tables

System Tables

Table Properties

Data

Creating Data Through PCC

Importing Data with Bulk Data Utility

Exporting Data

Triggers, Stored Procedures, User-defined Functions, and Views

Groups, Users, and Security

Security Tasks

Configuration

License Administrator

License Administrator Concepts

Graphical User Interface

Command Line Interface

User Count

Licenses for Prior Versions of Pervasive PSQL

License Administrator GUI Visual Reference

GUI Dialog

License Administrator Tasks

GUI Tasks

CLI Tasks

Table Editor

Table Editor Concepts

Overview

Table Editor Pages

GUI Visual Reference

Columns Page Interface

Table Editor Tasks

General Tasks

Columns Tasks

Indexes Tasks

Foreign Keys Tasks

SQL View Tasks

SQL Editor

SQL Editor Concepts

Overview

Restrictions

Displaying Statement Results

Outline Window View

Working with Common SQL Objects

SQL Editor Used in SQL View Tab of Table Editor

SQL Editor Tasks

General Tasks

Execution Tasks

Grid Tasks

Text View Tasks

Outline View Tasks

Common SQL Object Tasks

Pervasive System Analyzer (PSA)

PSA Concepts

PSA Functional Overview

Why Use PSA?

PSA Tests in Detail

Frequently Asked Questions

Introductory Network Information

PSA GUI Visual Reference

PSA Tasks

Analyze and Archive Tasks

Restore Archive Tasks

Delete Components or Archives Tasks

View Components Tasks

Test Active Installation Tasks

Other Tasks

Command Line Interface Utilities

CLI Utilities Overview

Platforms that Include CLI Utilities

Where to Find CLI Utilities

Cross-Platform CLI Utilities

Linux-Only CLI Utilities

bcfg

bdu

bmon

btadmin

butil

clilcadm

dbmaint

dsnadd

mkded

isql

psregedit

psregsvr

pvdbpass

pvddl

pvnetpass

rbldcli

Basic Troubleshooting

General Troubleshooting

Error Messages from PCC

Frequently Asked Questions

Installation

PCC

Security

Documentation

User Counts

Networking

Difficulty Accessing Data

ODBC and DDFs

Upgrading from Btrieve 6.15

Upgrading and Migration

Miscellaneous

Pervasive PSQL Resources and Contacts

Printed Documentation

Developer Center

Pervasive PSQL Knowledge Base

FTP Site

Online Documentation

Pervasive Library

Webinars

Subscription Based E-mail Services

DevTalk

Newsgroup

E-Mail Contacts

Technical Support