User's Guide - Index
A -
B -
C -
D -
E -
F -
G -
H -
I -
J -
K -
L -
M -
N -
O -
P -
Q -
R -
S -
T -
U -
V -
W -
X -
Z
A
Access conflict
Access methods
Access rights
cannot perform the operation
problems due to lack of O/S rights
Access to database
setting up
Accessing
remote database
ACS
viewing
Act as part of the operating system
Active Directory
create Pervasive_Admin group on domain controller
Admin share not supported
Administrative rights
for Active Directory
granting
troubleshooting
user rights policy
Administrator user
fast user switching
ADO
Advanced Operations Guide
Advantages of Pervasive.SQL
Analyzing
your system
Autostart
keeping Workgroup engine from autostarting
Available sessions
error in PCC if none available
B
Backup
online
Benefits
of Pervasive.SQL
BSTART, loading NSS volumes first
Btadmin utility
Bti.ini
Btrieve
and terminology
owner names
testing
version 6.x and Pervasive.SQL
Btrieve.nlm
mixing versions of NLMs not permitted
nwmkde.nlm and
SQL engine and
BTRV UNLINK
Bulk Data Utility
constraints
error logging
examples
BUTIL
Linux and
C
Cache
PCC
clearing
Cannot access data after upgrade
Case
GUI object in Table Editor
Cell, defined
Changing
hard coded file path in DDF
Client
definition of
DSN
defined
DSN setup 1 2
installation
password utility for use with
setting up database access
troubleshooting network protocols
Clilcadm utility
Clustering
Coexistence with previous versions
Collate
GUI object in Table Editor
Collating sequence
setting for column in Table Editor
Column
defined
Microsoft Access limited to 256 columns
too few when creating table for existing data
Column name
GUI object in Table Editor
Columns
allowing index duplicates in Table Editor
arranging order of index segment in Table Editor
deleting in Table Editor
deleting index in Table Editor
deleting index segment in Table Editor
inserting in Table Editor 1 2
inserting index segment in Table Editor
modifying index in Table Editor
modifying index segment in Table Editor
naming in Table Editor
selecting in Table Editor
setting case in Table Editor
setting collating sequence in Table Editor
setting data type in Table Editor
setting default in Table Editor
setting for nulls in Table Editor
setting index in Table Editor
setting precision in Table Editor
setting primary key in Table Editor
setting scale in Table Editor
setting size in Table Editor
specifying index as modifiable in Table Editor
specifying sort order for index in Table Editor
viewing those defined for a table
Columns page
in Table Editor
interface in Table Editor
Compatibility
between Server and Workgroup
between versions
where to find information
Components
of Pervasive.SQL
Concepts
basic database structures and terms
databases 1 2
ODBC standard
Configuration
bti.ini 1 2
defined
engine DSN
object properties in PCC
odbc.ini
properties for database
properties for database engine
properties for services
properties for table
server
O/S rights required
setting preferences for Grid
setting preferences for SQL Editor
setting preferences for Table Editor
setting preferences for Text window
setting preferences in PCC
setting properties for external tools
Conflict, access
Connection strings
'ServerDSN' or 'DBQ' not found in
Contacting
Pervasive resources
Continuous Operations
behavior after server failure
Control Center
See PCC
Converting
data files to older file format
Cost of ownership, lowest
Create Database Wizard
creating a Client DSN
creating an Engine DSN on NetWare
creating an Engine DSN on Windows
CREATE GROUP
CREATE USER
Creating
databases
O/S rights required
DDFs for old data, record size is wrong
table for existing data file, too few columns
Cross-platform support
D
Data
cannot access, troubleshooting
stored in files
Data compression
viewing
Data definitions
stored in files
Data files
converting to older file format
not affected by install/uninstall
re-use of space
similar
sharing of DDFs
Data replication
Data Source Names
about
Data table
Data types
and Columns page in Table Editor
Database
access
prerequisites
setting up
setting up on client
as object in PCC
concepts
defined 1 2
engine
administrative rights
definition of
starting
stopping
logging out from in PCC
mirroring
named
permissions
security
logging in as an administrator
security vs OS security
structures
Database administrator, not required
Database engine
as object in PCC
java.lang.UnsatisfiedLinkError error on Linux
logging in to in PCC
logging out from in PCC
reconnecting to in PCC
registering in PCC
running as service in PCC
setting services properties
setting startup policy
starting or stopping
SWT no more handles error on Linux
unable to connect to error on Linux
Database Management System
defined
functions of
Database names, cannot retrieve (error)
Database Server Engine
starting and stopping
Windows
Database Workgroup Engine
starting and stopping
Windows
Dbmaint utility 1 2
DBMS, see Database Management System
DBNAMES (Named Databases)
DBQ
not found in connection string
DDF Builder
DDF Ease
DDF path
viewing
DDF Sniffer
DDFs
changing hard-coded file path
detecting non-standard
how to keep safe
mixing among databases
must exist for ODBC access
sharing among data files
Default
GUI object in Table Editor
Definitions
cell
client
column
database 1 2
database engine
engine
field
index
join
local
record
remote
requester
row
schema
table
value
Deleted records, re-use of disk space
Deleting
DSN
Detecting
non-standard DDFs
Determining
if DDFs are non-standard
if ODBC interface is used
network protocol in use
service pack level
DevTalk, web forum
Dictionary path
viewing
Disk space
re-use of
Documentation
Advanced Operations Guide
different formats
Getting Started
Online help
Pervasive Products and Services
SQL Engine Reference
Status Codes and Messages
User's Guide
What's New
DSN
client
defined
Linux client
client DSN needed for many applications
concepts
engine
defined
on a Linux server
File DSN not supported 1 2
recreating 1 2
removing
Dsnadd utility 1 2
Dump file
cannot read it
Duplicate pointers
viewing number of
E
E-mail
Pervasive newsletter
Elements
of Pervasive.SQL
Engine
as object in PCC
components
different version than client
defined
DSN
defined
logging in to in PCC
logging out from in PCC
reconnecting to in PCC
registering in PCC
running as service in PCC
setting properties for
setting services properties
setting startup policy
starting or stopping
stopping Workgroup under fast user switching
tray icon with fast user switching
Error
'ServerDSN' or 'DBQ' not found
error 1114
Error was encountered message
troubleshooting
Existing data file
too few columns when creating table for
Expired licenses
hiding
Export
data from table
Export files
cannot read file
External tools
adding to PCC
F
Failover
FAQ, see Frequently asked questions
Fast user switching
running Workgroup engine
tray icon with
types of users for
Features
of Pervasive.SQL
Field, defined
Field.ddf
File
format
converting data to older
path
changing hard-coded in DDF
viewing file name associated with a table
viewing location of table
where data and metadata stored
File DSN not supported 1 2
File system security 1 2
File version
viewing
File.ddf
Files
explanation of required
Finding
information on upgrading
non-standard DDFs
service pack level
Foreign key
adding in Table Editor
deleting in Table Editor
modifying in Table Editor
Foreign keys page
in Table Editor
Freespace threshold
viewing
Frequently asked questions
G
Garbage collection
on disk
Getting Started guide
GRANT
Granting
administrative rights
for "this account"
on Linux
on NetWare 4.2, 5.x or 6.x
on Windows 2000
Grid
adding rows of data
changing data in
copying data from
deleting rows of data
in PCC
refreshing data in
setting preferences
using scalar functions
view in SQL Editor
Group
as object in PCC
H
How
to access data via ODBC from other applications
to apply a user count upgrade
to find
information
to grant a user administrative rights
for "this account"
on Linux
on NetWare 4.2, 5.x or 6.x
on Windows 2000
to login as administrator
to obtain more help
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 Linux
on NetWare
on Windows server 1 2 3
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
I
Identifying
service pack level
Import
data into table
Increasing user count licenses
Index
defined
Index balancing
viewing 1 2
Index.ddf
Indexes
allowing duplicates in Table Editor
arranging order of segment in Table Editor
deleting in Table Editor
deleting segment in Table Editor
inserting segment in Table Editor
modifying in Table Editor
modifying segment in Table Editor
setting in Table Editor
specifying as modifiable in Table Editor
specifying sort order in Table Editor
viewing number of
viewing those defined for a table
Indexes page
in Table Editor
Information
how to find
Installation
client FAQ
data files not affected by
reboot NetWare 5.x after
InstallScout
replaced by Pervasive System Analyzer
Interfaces
ADO
ODBC
OLE-DB
supported for programming
J
Java.lang.UnsatisfiedLinkError error on Linux
Join
defined
K
Key only file
viewing
L
Legacy data
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 help
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
display help
hide expired licenses
remove a license
select a computer for license administration
start as stand-alone application
start from PCC
GUI visual reference
license key
licenses for prior releases
tasks (how to)
user count 1 2
applying
obtaining
License count
increasing
See User count
License key
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
Licensing
workgroup engine
Limited user
fast user switching
Linux
client DSNs
engine DSNs
MicroKernel Database Engine, starting and stopping
naming databases
PCC
errors trying to start
java.lang.UnsatisfiedLinkError engine error
required conditions for starting
starting PCC
SWT no more handles engine error
troubleshooting starting
unable to connect to database engine error
utilities
btadmin
butil
clilcadm
dbmaint 1 2
dsnadd 1 2 3
mkded
Mkded, console mode
mkded, daemon mode
sqlmgr, bti.ini
sqlmgr, odbc.ini
Load balancing
Loading
database engine
NSS volumes before BSTART/MGRSTART
Local, defined
Log on authority for service
Log on failed
troubleshooting
Log out
from database
Login
OS vs DB
Lowest total cost of ownership
M
Map Root not supported
Maximum
users for workgroup engine
MGRSTART, loading NSS volumes first
MicroKernel Database Engine
defined
starting and stopping
Linux
NetWare
Microsoft
Access
accessing Pervasive.SQL data using
limited to 256 columns
Excel
accessing Pervasive.SQL data using
Migrating
NetWare to Windows server
where to find information
Windows server to NetWare
Mirroring, database
MKDE See MicroKernel Database Engine
Mkded utility
console mode
daemon mode
Monitor
O/S rights required
Multiple
processors
use of
N
Named databases
Naming
databases
dbmaint utility
from a Linux server
NetWare
alternate way to apply a license key
btrieve.nlm and SQL engine
load dependencies
MicroKernel Database Engine, starting and stopping
migrating to Windows server
NSS volumes
slower on updates
nwmkde.nlm and btrieve.nlm required
ODBC and
reboot 5.x after installing Pervasive.SQL
unloading Pervasive.SQL
Network
communications
verifying
protocol
determining
troubleshooting
Network communications
testing
Network password utility
New utilities
News
obtaining via e-mail
Non-standard DDFs
detecting
NSS volume support
Null
GUI object in Table Editor
Nulls
and Columns page in Table Editor
setting for column in Table Editor
Number of duplicate pointers
viewing
Number of indexes
viewing
Number of unused pages
viewing
Number or records
viewing
O
Object properties
accessing in PCC
ODBC
concepts
interface, determining if used
setting up on NetWare
Odbc.ini
OLE-DB provider
Online backup
Online documentation
format varies by computer
Online help
Operating system
security vs DB security
troubleshooting access rights
Outline window
in PCC
Outline window view
in SQL Editor
running all SQL statements
sizing
Owner names
and SQL security
Ownership, lowest total cost of
P
Page size
viewing
Pages
viewing number of unused
Password
troubleshooting wrong
utility used to manage
Passwords
utility used to manage
PCC
accessing object properties
clearing cache
configuration
database engine object
database engine running as a service
database object
editor characteristics
editors and window view within
external tools
setting preferences
Grid
group object
how to start on Linux
how to start on Windows
java.lang.UnsatisfiedLinkError error on Linux
logging in to server engine
logging out from database
logging out from server engine
Outline window
overview
Pervasive.SQL Explorer
Pervasive.SQL Explorer not showing installed or upgraded product
preferences
reconnecting to a server engine
registering a remote server engine
security
services
setting database engine properties
setting database properties
setting preferences
setting table properties
SQL Editor
stored procedure object
SWT no more handles error on Linux
Table Editor
table object
Text window
tree of objects
See Pervasive.SQL Explorer
trigger object
troubleshooting starting on Linux
unable to connect to database engine error on Linux
user object
user-defined function object
view object
window view characteristics
Performance
NSS volumes slower on updates
Permissions
for database
Pervasive Products and Services
Pervasive System Analyzer
Pervasive_Admin security group
use with Active Directory
Pervasive.SQL
advantages
benefits
client, defined
components of
explained
features
Server
server, defined
Workgroup
Pervasive.SQL 7
need to recreate DSNs
Pervasive.SQL Control Center
See PCC
Pervasive.SQL Explorer
accessing object properties
expanding tree objects
not showing installed or upgraded product in PCC
within PCC
Pervasive.SQL utilities. See Utilities. 1 2
Platform support
Precision
GUI object in Table Editor
Preferences
setting for Grid
setting for PCC
setting for SQL Editor
setting for Table Editor
setting for Text window
setting in PCC for external tools
Preserving DDFs
Primary key
setting for column in Table Editor
Programming interfaces supported
Properties
accessing in PCC
setting for database
setting for database engine
setting for services
setting for table
Protocol
determining network
PSA, see Pervasive System Analyzer
pvnetpass
authenticating to a domain server
Pvnetpass utility
PVSW.LOG
client and server compatibility
Q
Questions, frequently asked
R
Reconnect
to database engine in PCC
Record
defined
length
wrong when creating DDFs for old data
Record length
viewing
Records
viewing variable
Recreating DSNs 1 2
Redirected mapping not supported
Register
database engine in PCC
Relational access
setting up on NetWare
Remote
database access
defined
Removing
DSN
Replication
Requester
defined of
for SQL Relational Database Engine
troubleshooting client
Rights
administrative 1 2
granting administrative
for "this account"
on Linux
on NetWare 4.2, 5.x or 6.x
on Windows 2000
if changed from system account
Row, defined
Running
in trace mode
S
Scalable solution
Scalar functions
DATE in SQL Editor
TIME in SQL Editor
TIMESTAMP in SQL Editor
using within SQL Editor Grid
Scale
GUI object in Table Editor
Scheduling events
Schema, defined
Security
administrative rights
as object property in PCC
file system 1 2
logging in as administrator 1 2
OS login vs DB login
owner names vs SQL security
Server
DSN not found in connection string
troubleshooting network protocols
Service
database engine running as
log in authority for "this account"
setting properties
setting startup policy for database engine
starting or stopping database engine
stopping Workgroup engine when using fast user switching
Service pack
identifying level
Setting up
database access
database access on client
Shadowing, database
Shared files, troubleshooting
Size
GUI object in Table Editor
SmartScout
replaced by Pervasive System Analyzer
Smithware
SMP, see Multiple processors
SQL
CREATE GROUP
CREATE USER
GRANT
SQL Editor
adding rows of data within Grid
changing data within Grid
clearing results in Text window
copying data from Grid
creating SQL query or script
creating stored procedures
creating triggers
creating user-defined functions
creating views
deleting rows of data within Grid
deleting stored procedures
deleting triggers
deleting user-defined functions
deleting views
enabling SQL execution commands
finding text
Grid
identifying setting
modifying stored procedures
modifying triggers
modifying user-defined functions
modifying views
opening SQL script
Outline window view
overview
redoing an action
refreshing data in Grid
running all SQL statement
running all SQL statement in Outline window view
running single SQL statement
selecting text
selecting text in Text window
setting database context for query
setting preferences
sizing Outline window view
SQL statement separators
starting by showing all table records
starting for new query
stored procedures
Text window view
triggers
typing comments in
undoing an action
used in SQL View of Table Editor
user-defined functions
using scalar functions within Grid
views
SQL Engine Reference
SQL Relational Database Engine
defined
scheduler
setting up access on NetWare
SQL requester
SQL script
creating in SQL Editor
opening in SQL Editor
SQL statements
comments in
copying in Table Editor
creating query or script in SQL Editor
enabling commands to execute
finding text in
opening SQL script in SQL Editor
redoing typing in SQL Editor
running all in SQL Editor
running in SQL Editor Outline window view
running single in SQL Editor
selecting text in
separators in SQL Editor
setting database context in SQL Editor for query
starting SQL Editor
starting SQL Editor by showing all table records
typing comments in SQL Editor
undoing typing in SQL Editor
SQL View
in Table Editor
SQL view page
in Table Editor
Sqlmgr utility
bti.ini
odbc.ini
Start up
keeping Workgroup engine from autostarting
Starting
database engine
Startup policy
for database engine
Status Codes and Messages
Stopping
database engine
Workgroup engine under fast user switching
Stored procedure
as object in PCC
creating in SQL Editor
deleting in SQL Editor
in SQL Editor
modifying in SQL Editor
Support
cross-platform
Switching, fast user
SWT no more handles error on Linux
Symmetric Multiprocessing, see Multiple processors
System account rights
System data key
viewing 1 2
System tables
T
Table
as object in PCC
creating data for
data
defined
exporting data from
importing data into
system
viewing
variable record blank truncation
viewing alternate collating sequence
viewing data compression
viewing dictionary path
viewing file version
viewing freespace threshold
viewing index balancing
viewing key only file
viewing location of file
viewing name
viewing number of duplicate pointers
viewing number of indexes
viewing number of records
viewing number of unused pages
viewing page size
viewing physical file name associated with
viewing record length
viewing system data key
viewing variable records
Table columns
viewing
Table Editor
adding a foreign key
allowing index duplicates
arranging order of index segment
columns page
columns page interface
copying SQL statement
creating an index
deleting a column
deleting a foreign key
deleting an index
deleting an index segment
foreign keys page
identifying tables with changes pending
in PCC
indexes page
inserting an index segment
inserting columns 1 2
modifying a foreign key
modifying an index
modifying an index segment
naming a column
overview
saving changes for all edited tables
saving changes to an edited table
selecting columns
setting a column data type
setting column case
setting column collating sequence
setting column default
setting column nulls
setting column precision
setting column primary key
setting column scale
setting column size
setting preferences
specifying index as modifiable
specifying sort order for index
SQL View
SQL view page
starting for a new table
starting for an existing table
tasks performed with
undoing or redoing changes
viewing SQL statements applicable to the table
viewing table data
work area pages
working with columns
working with foreign keys
working with indexes 1 2
Table file location
viewing
Table indexes
viewing
Table name
viewing
viewing physical file name associated with
Terminal Server
Terminology
Btrieve usage
cell
client
column
database
database engine
engine
field
index
join
local
record
remote
requester
row
schema
table
value
Testing
your system
Text window
in PCC
setting preferences
Text window view
clearing results in
in SQL Editor
selecting text in
Tools
adding external to PCC
Trace
how to run in trace mode
Tray icon
with fast user switching
Trigger
as object in PCC
creating in SQL Editor
deleting in SQL Editor
in SQL Editor
modifying in SQL Editor
Troubleshooting
ruling out possible causes
client DSN not available
disabled client requester
network outage
no server (engine) DSN available
OS permissions problems
server not accepting requests
server not running, not installed
wrong network protocol settings
Type
GUI object in Table Editor
U
Unable to connect error
troubleshooting
Unable to connect to database engine error on Linux
Unauthorized access
to data file with owner name
Understanding
databases 1 2
Uninstalling
data files not affected
Unloading
database engine
Pervasive.SQL on NetWare
Unused pages
viewing number of
Updates
slower on NetWare NSS volumes
Upgrading
can't get to data after
user count
where to find information
User
as object in PCC
User count
administering with License Administrator
applying
determining total
how to apply
license key 1 2
obtaining
troubleshooting expired license
workgroup engine
User name
OS vs DB
troubleshooting wrong
utility used to manage
User rights policy
act as part of the operating system
for "this account"
User switching
User-defined function
as object in PCC
creating in SQL Editor
deleting in SQL Editor
in SQL Editor
modifying in SQL Editor
User's Guide
Users
types of for fast user switching
Uses alternate collating sequence
viewing
Utilities
btadmin
butil
clilcadm
dbmaint 1 2
dsnadd 1 2
for Linux
License Administrator
mkded
console mode
daemon mode
new
overview 1 2 3
sqlmgr
bti.ini
odbc.ini
V
Value
defined
Variable record blank truncation
viewing
Variable records
viewing 1 2
Version
new, data files not affected by installing
old, data files not affected by uninstalling
viewing file
View
as object in PCC
creating in SQL Editor
deleting in SQL Editor
in SQL Editor
modifying in SQL Editor
W
Web, scalable to
What's New
Windows
Database Server Engine, starting and stopping
Database Workgroup Engine, starting and stopping
XP operating system
fast user switching
running Workgroup engine with fast user switching
support for
tray icon with fast user switching
types of users for fast user switching
Windows server
migrating to NetWare
Workgroup engine
database access
keeping from autostarting
licensing
maximum users
simultaneous access
stopping under fast user switching
X
XP
see Windows XP operating system
Xtrieve
replacement for
Z
Z-DBA
