User's Guide - Table of Contents

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

About This Manual

Who Should Read This Manual

Manual Organization

Conventions

Introducing Pervasive.SQL

Understanding Pervasive.SQL

What is a Database?

What is a Database Management System?

Components of Pervasive.SQL

Key Concepts

Basic Database Structures and Terms

Unique Benefits of Pervasive.SQL

Why Pervasive.SQL?

Understanding the Product Family

Workgroup

Server

DataExchange

Crystal Reports for Pervasive.SQL

Helpful Utilities

Using Pervasive.SQL Documentation

Getting Started Guides

What's New

User's Guide

Advanced Operations Guide

SQL Engine Reference

Status Codes and Messages

Pervasive Products and Services

Online Help

File System Security

Using Pervasive.SQL

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

What to Know if You are Recreating DSNs

Prerequisites to Setting up Database Access

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

Bound Databases and Enforced Integrity

Using the Fast User Switching Feature of Windows XP

Using the Pervasive Control Center

An Overview of Pervasive Control Center

Registering or Removing a Server

Viewing Database Engines

Interpreting Engine Status Icons

Pervasive Control Center Wizards

Adding or Creating a Database

Deleting a Database

Adding a Table

Dropping a Table

Setting Database Security

Turning Security On and Off

Working with Groups and Users

Stopping and Restarting Services on Windows Servers

Viewing and Modifying Table Properties

Viewing and Modifying Data

Exporting/Importing Data

Export and Import Procedures

Checking Consistency and Referential Integrity

Listing Referential Constraints

Checking Consistency

Checking Referential Integrity

License Administrator

License Administrator Concepts

Graphical User Interface

Command Line Interface

User Count

Licenses for Prior Versions of Pervasive.SQL

License Administrator GUI Visual Reference

GUI Dialog

License Administrator Tasks

GUI Tasks

CLI Tasks

Table Designer

Table Designer Concepts

Overview

Tabbed Dialogs

Modes

Data Types

Null Values

Table Designer GUI Visual Reference

Main Window

Columns Tab

Indexes Tab

Statistics Tab

Btrieve Tab

Table Designer Tasks

General Tasks

Columns Tasks

Indexes Tasks

Statistics Tasks

Btrieve Tasks

SQL Data Manager

SQL Data Manager Concepts

Overview

Restrictions

Results Tabs

Panes

SQL Reference

SQL Data Manager GUI Visual Reference

Main Window

Query Builder Diagram

Query Builder Grid for SELECT Statements

Query Builder Grid for UPDATE Statements

Query Builder Grid for INSERT Statements

Query Builder Grid for DELETE Statements

SQL Data Manager Tasks

General Tasks

Query Pane Tasks

Execution and Results Tasks

Query Builder 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

Linux Supplementary Documentation

User Manual Exclusions for Linux

Utilities

Changes and Exclusions

Man Pages

Linux Utilities

btadmin

butil

clilcadm

dbmaint

dsnadd

mkded

odbctest

psregedit

psregsvr

pvdbpass

pvnetpass

rbldcli

sqlmgr

Basic Troubleshooting

General Troubleshooting

Error Messages from PCC

Frequently Asked Questions

Installation

Security

Documentation

User Counts

Networking

Difficulty Accessing Data

ODBC and DDFs

Upgrading from Btrieve 6.15

Upgrading and Migration

Miscellaneous

Pervasive.SQL Resources and Contacts

Printed Documentation

Developer Center

Pervasive.SQL Knowledge Base

FTP Site

Online Documentation

Pervasive Library

Webinars

Subscription Based E-mail Services

DevTalk

Newsgroup

E-Mail Contacts

Technical Support