Library > Products > Pervasive.SQL > Pervasive.SQL 8.7 > User's Guide > Pervasive.SQL Resources and Contacts > usrguide-11-13.html

Previous

User's Guide (8.7 revision 1)

User's Guide - Index

A - B - C - D - E - F - G - H - I - J - L - M - N - O - P - Q - R - S - T - U - V - W - X - Z

Access conflict

cannot perform the operation

problems due to lack of O/S rights

See also Rights

remote database

Act as part of the operating system

Active Directory

create Pervasive_Admin group on domain controller 1 2

See SQL Data Manager

Add column button

Add index button

Add segment button

See also Table Designer

See Table Designer

Admin share not supported

Administrative rights

for Active Directory

required to create a database

troubleshooting

user rights policy

Administrator user

fast user switching

Advanced Operations Guide

Advantages of Pervasive.SQL

keeping Workgroup engine from autostarting

Available sessions

error in PCC if none available

of Pervasive.SQL

Bound databases

BSTART, loading NSS volumes first

Btadmin utility

and terminology

version 6.x and Pervasive.SQL

mixing versions of NLMs not permitted

Cannot access data after upgrade

hard coded file path in DDF

order of columns

Check Database Wizard

database consistency

setting up database access

troubleshooting network protocols

Clilcadm utility

Coexistence with previous versions

changing order of

Microsoft Access limited to 256 columns

set case sensitivity

set collating sequence

set to allow or disallow nulls

too few when creating table for existing data

Commenting SQL statements

between Server and Workgroup

between versions

where to find information

of Pervasive.SQL

basic database structures and terms

delay in, eliminating 1 2

O/S rights required

Conflict, access

Connection strings

'ServerDSN' or 'DBQ' not found in

Consistency checking

Pervasive resources

Continuous Operations

behavior after server failure

data files to older file format

v3.01 DDFs to current version

Cost of ownership, lowest

Create Database Wizard

creating a Client DSN

creating an Engine DSN on NetWare

creating an Engine DSN on Windows

prerequisites to creating a database

CREATE PROCEDURE

error code -4994

Create Table Wizard

column attributes

O/S rights required

See Table Designer

DDFs for existing data

DDFs for old data, record size is wrong

table for existing data file, too few columns

tables See also Table Designer

Creating an SQL query with SQL Data Manager

Cross-platform support

cannot access, troubleshooting

stored in files

Data definitions

stored in files

Data Dictionary Files See DDFs

Data Export Wizard

changing location of

converting to older file format

not affected by install/uninstall

re-use of space

sharing of DDFs

Data Import Wizard

Data replication

Data Source Names

setting up on client

consistency checking

administrative rights

inconsistencies, check database wizard and

logging in as an administrator

security vs OS security

Database administrator, not required

Database Management System

Database names, cannot retrieve (error)

Database Server Engine

starting and stopping

Database Workgroup Engine

starting and stopping

Dbmaint utility 1 2

DBMS, see Database Management System

DBNAMES (Named Databases)

not found in connection string

DDF Builder 1 2

DDF Sniffer 1 2

building for existing data

changing hard-coded file path

converting from old version

detecting non-standard

how to keep safe

mixing among databases

must exist for ODBC access

sharing among data files

verifying against data files

database engine

in Configuration, eliminating 1 2

Delete Database Wizard

Deleted records, re-use of disk space

See Table Designer

non-standard DDFs

if DDFs are non-standard

if ODBC interface is used

network protocol in use

service pack level

DevTalk, web forum

Directory field

in Create Database Wizard

Advanced Operations Guide

different formats

Getting Started

Pervasive Products and Services

SQL Engine Reference

Status Codes and Messages

Drop Database Wizard

Drop Table Wizard

See also Table Designer

client DSN needed for many applications

creating on NetWare

on a Linux server

File DSN not supported 1 2

Dsnadd utility 1 2

Pervasive newsletter

of Pervasive.SQL

Enforcing Referential Integrity

different version than client

stopping Workgroup under fast user switching

tray icon with fast user switching

'ServerDSN' or 'DBQ' not found

Error was encountered message

troubleshooting

pasting data from SQL Data Manager

Existing data file

creating DDFs for

too few columns when creating table for

cannot read file

Export Wizard See Data Export Wizard

FAQ, see Frequently asked questions

Fast user switching

running Workgroup engine

types of users for

of Pervasive.SQL

converting data to older

version upgrade not needed for SQL access

changing hard-coded in DDF

where data and metadata stored

File DSN not supported 1 2

File system security 1 2

explanation of required

information on upgrading

non-standard DDFs

service pack level

modifying table definition and

Frequently asked questions

Garbage collection

Getting Started guide

administrative rights

for "this account"

on NetWare 4.2, 5.x or 6.x

on Windows 2000

See SQL Data Manager

adding a user to

adding to database

to access data via ODBC from other applications

existing user to a group

new user to the database

to apply a user count upgrade

for orphan rows

referential integrity

whether table definitions match data file structure

new table in a database

table definition for an existing data file

existing database

existing table from a database

to display table properties

to export data from an existing table

to grant a user administrative rights

for "this account"

on NetWare 4.2, 5.x or 6.x

on Windows 2000

to import data into an existing table

to interpret engine status icons in PCC

to list referential constraints

to login as administrator

to obtain more help

to register a remote server in PCC

to remove a remote server from PCC 1 2

to set up a client DSN

on a Linux workstation

using ODBC Administrator

to set up database access

for a client workstation

on a Linux server

on a NetWare server

on a Windows server

on a Workstation or Workgroup engine

to start and stop database engine

on Windows server 1 2 3

to start and stop Windows services within PCC

to start database engine by using Net Start or Btisc.exe

on Windows server

to stop database engine by using Net Stop or Btisc.exe

on Windows server

to turn off database security

database security

to verify database consistency

registered database engines

in PCC, interpreting

service pack level

Import Wizard, see Data Import Wizard

Inconsistencies, database

Increasing user count licenses

See Table Designer

data files not affected by

reboot NetWare 5.x after

replaced by Pervasive System Analyzer

Integrity enforced

supported for programming

Joining tables in SQL Data Manager 1 2

creating DDFs for

Legacy file format

converting data files to

License Administrator

alternate way to apply a license key on NetWare

CLI tasks (how to)

apply license key

display all applied licenses

display specific license

remove a license

command line interface

graphical user interface

GUI tasks (how to)

apply license key

determine total user count

display applied license

remove a license

select a computer for license administration

start as stand-alone application

GUI visual reference

licenses for prior releases

administering licenses with License Administrator

and user count 1 2

applying a key 1 2

applying user count

determining total user count

displaying a specific license

displaying all applied licenses 1 2

for prior releases

obtaining user count

removing a license 1 2

starting License Administrator 1 2

workgroup engine

fast user switching

See Table Designer

MicroKernel Database Engine, starting and stopping

naming databases

user manual exclusions

changes/exclusions

Mkded, console mode

mkded, daemon mode

sqlmgr, bti.ini 1 2 3

sqlmgr, console mode

sqlmgr, daemon mode

sqlmgr, odbc.ini 1 2

database engine

NSS volumes before BSTART/MGRSTART

changing for table data file

Log on authority for service

troubleshooting

creating with Query Builder

Lowest total cost of ownership

Map Root not supported

users for workgroup engine

MGRSTART, loading NSS volumes first

MicroKernel Database Engine

starting and stopping

accessing Pervasive.SQL data using

limited to 256 columns

accessing Pervasive.SQL data using

NetWare to Windows server

where to find information

Windows server to NetWare

Mirroring, database

MKDE See MicroKernel Database Engine

table properties

See Table Designer

O/S rights required

in Create Database Wizard

Named databases

dbmaint utility

from a Linux server

alternate way to apply a license key

btrieve.nlm and SQL engine

load dependencies

MicroKernel Database Engine, starting and stopping

migrating to Windows server

slower on updates

nwmkde.nlm and btrieve.nlm required

reboot 5.x after installing Pervasive.SQL

unloading Pervasive.SQL

troubleshooting

Network communications

obtaining via e-mail

Non-standard DDFs

NSS volume support

modifying table definition and

restrictions for column

Null Conversion Wizard

interface, determining if used

setting up on NetWare

OLE-DB provider

Online documentation

format varies by computer

Operating system

security vs DB security

troubleshooting access rights

Order of columns

Pervasive Control Center

and SQL security

cannot use PCC to grant permissions for files with owner names

Ownership, lowest total cost of

troubleshooting wrong

NSS volumes slower on updates

Pervasive Control Center 1 2 3 4

accessing a remote server

column attributes

Create Table Wizard

creating tables

See Table Designer

Delete Database Wizard

eliminating delay in Configuration

interpreting engine icons

registering a remote server

setting database security

SQL Data Manager

stopping and restarting services

turning security on/off and

viewing and modifying table properties

See Table Designer

viewing database engines

wizards available

Pervasive Products and Services

Pervasive System Analyzer

Pervasive_Admin security group

use with Active Directory 1 2

client, defined

server, defined

Pervasive.SQL 7

need to recreate DSNs

Pervasive.SQL utilities. See Utilities. 1 2

Platform support

Preserving DDFs

modifying table definition and

Programming interfaces supported

determining network

PSA, see Pervasive System Analyzer

client and server compatibility

See SQL Data Manager

Query Builder Diagram

See SQL Data Manager

Query Builder Grid

See SQL Data Manager

Query timeout period

Questions, frequently asked

wrong when creating DDFs for old data

Recreating DSNs 1 2

Redirected mapping not supported

Referential constraints

Referential integrity

how to check integrity

Registering a remote engine in PCC

Relational access

setting up on NetWare

database access

Remove column button

Remove index button

Remove segment button

See Table Designer

a remote engine from PCC

See Table Designer

database inconsistencies

for SQL Relational Database Engine

troubleshooting client

administrative 1 2

required to create a database

granting administrative

for "this account"

on NetWare 4.2, 5.x or 6.x

on Windows 2000

if changed from system account

orphan,checking for

Scalable solution

converting v3.01 DDFs to current version

Scheduling events

Schema, defined

administrative rights

file system 1 2

logging in as administrator 1 2

OS login vs DB login

owner names vs SQL security

turning database security off

turning database security on

DSN not found in connection string

registering in PCC

troubleshooting network protocols

log in authority for "this account"

stopping Workgroup engine when using fast user switching

identifying level

starting and stopping with PCC

Database Security

database access

Access to database

database access on client

Shadowing, database

Shared files, troubleshooting

replaced by Pervasive System Analyzer

SMP, see Multiple processors

executing statements

SQL Data Manager

aggregate functions

AVG (average) aggregate function

commenting lines

Count aggregate function

criteria operators

getting started with

joining two tables 1 2

main window GUI reference

Add Table command

Change Query Type command

Developer Center (Web)

Grid Results tab

Group By command

Insert/Overtype indicator

Knowledge Base (Web)

New SQL Query command

Online Manuals (Web)

Open SQL Query command

Progress indicator

Query Builder Diagram command

Query Builder Grid command

Query Pane command

Rows fetched indicator

Run All SQL Statements command

Run Current SQL Statement in Grid command

Run Current SQL Statement in Text command

Save SQL Query As

Save SQL Query command

Search Documentation

Set Font command

Text Results tab

MAX (maximum) aggregate function

MIN (minimum) aggregate function

paste copied data into Excel

primary work areas

mixing use of statements

SQL statements to build with

Query Builder Diagram

behavior when no tables in Diagram

joining two tables 1 2

symbols used in table window

Query Builder Diagram GUI reference

Query Builder Grid

behavior when no tables in Query Builder Diagram

grid for DELETE statements

grid for INSERT statements

grid for SELECT statements

grid for UPDATE statements

grids specific to SQL statement types

Query Builder Grid GUI reference for DELETE

Query Builder Grid GUI reference for INSERT

Query Builder Grid GUI reference for SELECT

Query Builder Grid GUI reference for UPDATE

cursor movement within

records fetched indicator

Grid Results tab 1 2

states of Grid Results

Text Results tab

SQL statements to use with

SUM aggregate function

add a Group By column to Query Builder Grid

add a table to Query Builder Diagram

build a DELETE statement with Query Builder

build a SELECT statement with Query Builder

build an INSERT statement with Query Builder

build an UPDATE statement with Query Builder

cancel (undo) typing actions in Query Pane

cancel an undo action (redo) in Query Pane

change data with Grid Results grid

clear results from Text Results tab

clear the contents of a row(s) on Query Builder Grid

close a database

continue running SQL statements that were stopped

copy text from Grid Results tab

copy text from Query Pane

copy text from Text Results tab

create an SQL query or script

cut or delete text from Query Pane

cut or delete text from Text Results tab

delete row(s) from Grid Results tab

delete row(s) on Query Builder Grid

find text in Query Pane

identify machine and database currently open

insert a row into Query Builder Grid

joint tables in Query Builder Diagram

layout the printed page

move the cursor within Query Pane and run the SQL statement to which it moves

move the cursor within Query Pane without running any SQL statements

open a database

open an SQL script

paste within Query Pane

print the contents of Query Pane

remove a table from Query Builder Diagram

replace text in Query Pane

run a single SQL statement

run all SQL statements

save an SQL query as a script

select text in Query Pane

select text on Text Results tab

set default behavior for Grid Results grid

set Grid Results grid to allow changes to database data

set query timeout period

set query type for Query Builder

set SQL statement separator

set the font for grid results or text results

set the font for Query Pane

show or hide Query Builder Diagram

show or hide Query Builder Grid

show or hide Query Pane

start SQL DM as a stand-alone application

start SQL DM from PCC

stop running SQL statements

toggle insert/overtype mode

type a comment into Query Pane

work with grid results

work with text results

wrap text within Query Pane

See SQL Data Manager

SQL Engine Reference

creating with SQL Data Manager

SQL Relational Database Engine

early file formats and

setting up access on NetWare

SQL statement timeout period

commenting lines

use with SQL Data Manager

Sqlmgr utility 1 2

keeping Workgroup engine from autostarting

database engine

services with PCC

Status Codes and Messages

database engine

services with PCC

Workgroup engine under fast user switching

Stored procedures

error code -4994 when creating

Switching, fast user

Symmetric Multiprocessing, see Multiple processors

System account rights

changing location of data file

column attributes

See Table Designer

displaying information about

verifying against data file structure

viewing data from Table Designer

graphical user interface 1 2

null restrictions for column

Btrieve tab 1 2

columns tab 1 2

indexes tab 1 2

statistics tab 1 2

allow duplicates in index

change Btrieve column position

change column order

change location of table data file

delete Btrieve column

delete index segment

determine record length

discard all changes

display table information

display table statistics

identify active database and table

identify changes that have not been saved

insert Btrieve column 1 2

insert column 1 2

insert index segment

set Btrieve column case sensitivity

set Btrieve column decimal places

set Btrieve column name

set Btrieve column size

set Btrieve column to allow nulls

set Btrieve column type

set column case sensitivity

set column collating sequence

set column data type

set column default

set column name

set column precision

set column scale

set column size

set column to allow or disallow nulls

specify index as modifiable

specify index sort column

specify index sort sequence

view table data

work with Btrieve data

work with columns

work with indexes

See Table Designer

See Table Designer

See Table Designer

See Table Designer

Terminal Server

database engine

See SQL Data Manager

Timeout period for an SQL query

how to run in trace mode

with fast user switching

Troubleshooting

ruling out possible causes

client DSN not available

disabled client requester

no server (engine) DSN available

OS permissions problems

server not accepting requests

server not running, not installed

wrong network protocol settings

Unable to connect error

troubleshooting

Unauthorized access

to data file with owner name

data files not affected

See Table Designer

database engine

Pervasive.SQL on NetWare

slower on NetWare NSS volumes

can't get to data after

where to find information

Use advanced settings field

in Create Database Wizard

adding to a group

adding to database

administering with License Administrator

determining total

license key 1 2

troubleshooting expired license

workgroup engine

troubleshooting wrong

User rights policy

act as part of the operating system

for "this account"

files with owner names and

types of for fast user switching

Users namespace node

cannot use with files that have owner names

License Administrator

bti.ini 1 2 3 4

new, data files not affected by installing

old, data files not affected by uninstalling

table properties

Viewing and modifying table properties

See Table Designer