User's Guide - Table of Contents

Pervasive PSQL v10 (show all 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

Understanding the DBMS Products

Workgroup

Server

Crystal Reports for Pervasive PSQL

Using Pervasive PSQL Documentation

Getting Started

What's New

User's Guide

Advanced Operations Guide

SQL Engine Reference

Status Codes and Messages

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 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 Linux

Logging in as Administrator on any platform

Setting Up ODBC Database Access

ODBC Standard

Servers and Clients

Data Source Names

Internal Database Name

Applications Using the Transactional Interface

Pervasive.SQL v7 users

Setting up Database Access with PCC

Setting Up Database Access on Windows

Setting Up Database Access on a Linux Server

Setting Up Client Access

Setting Up a Client DSN on a Linux Workstation

Accessing Data on a Remote Engine Using PCC

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 on Windows

Starting PCC On Linux

Editors and Views Within PCC

Preferences

Additional Utilities

External Tools

Services on Windows Servers

Services Properties

Database Engines

Database Engine Properties

Databases

Database Properties

New Database GUI Reference

Pervasive PSQL Database Tasks

Tables

Data Tables

System Tables

Table Properties

Data

Creating Data Through PCC

Importing Data with Bulk Data Utility

Importing Data with Import Data Wizard

Exporting Data with Export Data Wizard

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

Groups, Users, and Security

Security Tasks

Configuration

License Administrator

License Administrator Concepts

License Key Platform

User Count

Terminal Server Licensing

Licenses for Prior Versions of Pervasive PSQL

Graphical User Interface (GUI)

GUI Visual Reference

Command Line Interface (CLI)

CLI Syntax

License Administrator Tasks

GUI Tasks

CLI Tasks

Table Editor

Table Editor Concepts

Overview

Table Editor Pages

Table Editor 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

Frequently Asked Questions

PSA GUI Visual Reference

PSA Tasks

General Tasks

View Modules Tasks

Test Active Installation Tasks

Log Files 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

psc

psregedit

psregsvr

pvdbpass

pvddl

pvmdconv

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

Thirty-Day Free Technical Support