| Prev | Contents |
A - B - C - D - E - F - G - H - I - J - K - L - M - N - O - P - Q - R - S - T - U - V - W - X - Y - Z
User's Guide - Index
A
Access conflict 1
Access methods 1
adding a group 1
adding a user 1
cannot perform the operation 1
problems due to lack of O/S rights 1
remote database 1
Act as part of the operating system 1
create Pervasive_Admin group on domain controller 1, 2
Add column button 1
Add index button 1
Add segment button 1
databases 1
groups 1
tables 1
users 1
Admin share not supported 1
Administrative rights 1
for Active Directory 1
granting 1
required to create a database 1
troubleshooting 1
user rights policy 1
fast user switching 1
ADO 1
Advanced Operations Guide 1
Advantages of Pervasive.SQL 1
your system 1
column 1
keeping Workgroup engine from autostarting 1
error in PCC if none available 1
B
online 1
of Pervasive.SQL 1
Bound databases 1
BSTART, loading NSS volumes first 1
Btadmin utility 1
and terminology 1
owner names 1
testing 1
version 6.x and Pervasive.SQL 1
mixing versions of NLMs not permitted 1
nwmkde.nlm and 1
SQL engine and 1
BTRV UNLINK 1
Linux and 1
C
Cannot access data after upgrade 1
Cell, defined 1
hard coded file path in DDF 1
order of columns 1
name of .exe 1
Checkdb.exe 1
database consistency 1
definition of 1
DSN 1
defined 1
installation 1
setting up database access 1
troubleshooting network protocols 1
Clilcadm utility 1
Clustering 1
CNVDDF utility 1
Coexistence with previous versions 1
attributes 1
changing order of 1
defined 1
deleting 1
inserting 1
Microsoft Access limited to 256 columns 1
set case sensitivity 1
set collating sequence 1
set data type 1
set default 1
set name 1
set precision 1
set scale 1
set size 1
set to allow or disallow nulls 1
too few when creating table for existing data 1
Commenting SQL statements 1
between Server and Workgroup 1
where to find information 1
of Pervasive.SQL 1
basic database structures and terms 1
ODBC standard 1
engine DSN 1
O/S rights required 1
Conflict, access 1
'ServerDSN' or 'DBQ' not found in 1
Consistency checking 1
Pervasive resources 1
behavior after server failure 1
data files to older file format 1
v3.01 DDFs to current version 1
Cost of ownership, lowest 1
creating a Client DSN 1
creating an Engine DSN on NetWare 1
creating an Engine DSN on Windows 1
name of .exe 1
prerequisites to creating a database 1
CREATE GROUP 1
error code -4994 1
column attributes 1
name of .exe 1
CREATE USER 1
Createdb.exe 1
databases 1
O/S rights required 1
DDFs for existing data 1
DDFs for old data, record size is wrong 1
DSN on NetWare 1
table for existing data file, too few columns 1
tables 1
tables See also Table Designer1
users 1
Creating an SQL query with SQL Data Manager 1
Cross-platform support 1
Crtblwzd.exe 1
D
cannot access, troubleshooting 1
exporting 1
importing 1
modifying 1
stored in files 1
viewing 1
stored in files 1
Data Dictionary Files See DDFs1
Data Export Wizard 1
name of .exe 1
changing location of 1
converting to older file format 1
not affected by install/uninstall 1
re-use of space 1
sharing of DDFs 1
Data Import Wizard 1
name of .exe 1
Data replication 1
about 1
prerequisites 1
setting up 1
setting up on client 1
binding 1
concepts 1
consistency checking 1
administrative rights 1
definition of 1
starting 1
with PCC 1
stopping 1
with PCC 1
inconsistencies, check database wizard and 1
mirroring 1
named 1
securing a 1
logging in as an administrator 1
security vs OS security 1
structures 1
Database administrator, not required 1
defined 1
functions of 1
Database names, cannot retrieve (error) 1
Windows NT 1
Windows 1
adding 1
creating 1
deleting 1
removing 1
dbmaint 1
DBMS, see Database Management System1
DBNAMES (Named Databases) 1
not found in connection string 1
DDFs 1
building for existing data 1
changing hard-coded file path 1
converting from old version 1
detecting non-standard 1
how to keep safe 1
mixing among databases 1
must exist for ODBC access 1
sharing among data files 1
verifying against data files 1
cell 1
client 1
column 1
database engine 1
engine 1
field 1
index 1
join 1
local 1
Namespace 1
record 1
remote 1
requester 1
row 1
schema 1
table 1
value 1
in Configuration, eliminating 1, 2
Delete Database Wizard 1
Deleted records, re-use of disk space 1
a table 1
databases 1
DSN 1
group 1
user 1
non-standard DDFs 1
if DDFs are non-standard 1
if ODBC interface is used 1
network protocol in use 1
record length 1
service pack level 1
DevTalk, web forum 1
in Create Database Wizard 1
re-use of 1
Documentation 1
Advanced Operations Guide 1
different formats 1
Getting Started 1
Online help 1
Pervasive Products and Services 1
SQL Engine Reference 1
Status Codes and Messages 1
User's Guide 1
What's New 1
name of .exe 1
name of .exe 1
Dropdb.exe 1
a table 1
Droptab.exe 1
client 1
defined 1
Linux client 1
client DSN needed for many applications 1
concepts 1
creating on NetWare 1
defined 1
on a Linux server 1
removing 1
cannot read it 1
E
of Pervasive.SQL 1
Pervasive newsletter 1
Enforcing Referential Integrity 1
different version than client 1
defined 1
DSN 1
defined 1
stopping Workgroup under fast user switching 1
tray icon with fast user switching 1
'ServerDSN' or 'DBQ' not found 1
-4994 1
error 1114 1
troubleshooting 1
pasting data from SQL Data Manager 1
creating DDFs for 1
too few columns when creating table for 1
cannot read file 1
Export Wizard See Data Export Wizard1
Exporting data 1
expwizrd.exe 1
F
Failover 1
FAQ, see Frequently asked questions1
Fast user switching 1
running Workgroup engine 1
tray icon with 1
types of users for 1
of Pervasive.SQL 1
Field, defined 1
Field.ddf 1
converting data to older 1
version upgrade not needed for SQL access 1
changing hard-coded in DDF 1
where data and metadata stored 1
File.ddf 1
explanation of required 1
information on upgrading 1
non-standard DDFs 1
service pack level 1
modifying table definition and 1
Frequently asked questions 1
G
on disk 1
Getting Started guide 1
GRANT 1
administrative rights 1
for "this account" 1
on Linux 1
on NetWare 4.2, 5.x or 6.x 1
on Windows 2000 1
on Windows NT 1
adding a user to 1
adding to database 1
deleting 1
H
to access data via ODBC from other applications 1
existing user to a group 1
new user to the database 1
to apply a user count upgrade 1
for orphan rows 1
referential integrity 1
whether table definitions match data file structure 1
new database 1
new table in a database 1
table definition for an existing data file 1
existing database 1
existing table from a database 1
existing user 1
to display table properties 1
to export data from an existing table 1
information 1
to grant a user administrative rights
for "this account" 1
on Linux 1
on NetWare 4.2, 5.x or 6.x 1
on Windows 2000 1
on Windows NT 1
to import data into an existing table 1
to interpret engine status icons in PCC 1
to list referential constraints 1
to login as administrator 1
to obtain more help 1
to register a remote server in PCC 1
to remove a remote server from PCC 1, 2
on a Linux workstation 1
using ODBC Administrator 1
for a client workstation 1
on a Linux server 1
on a NetWare server 1
on a Windows server 1
on a Workstation or Workgroup engine 1
to start and stop database engine
on Linux 1
on NetWare 1
to start and stop Windows services within PCC 1
to start database engine by using Net Start or Btisc.exe
on Windows server 1
to stop database engine by using Net Stop or Btisc.exe
on Windows server 1
to turn off database security 1
database security 1
to verify database consistency 1
registered database engines 1
I
in PCC, interpreting 1
service pack level 1
Import Wizard, see Data Import Wizard1
Importing data 1
impwizrd.exe 1
repairing 1
Increasing user count licenses 1
defined 1
Index.ddf 1
how to find 1
a column 1
client FAQ 1
data files not affected by 1
reboot NetWare 5.x after 1
replaced by Pervasive System Analyzer 1
Integrity enforced 1
ADO 1
ODBC 1
OLE-DB 1
supported for programming 1
J
defined 1
Joining tables in SQL Data Manager 1, 2
L
creating DDFs for 1
converting data files to 1
License Administrator 1
alternate way to apply a license key on NetWare 1
apply license key 1
display all applied licenses 1
display help 1
display specific license 1
remove a license 1
command line interface 1
graphical user interface 1
apply license key 1
determine total user count 1
display applied license 1
display help 1
remove a license 1
select a computer for license administration 1
start as stand-alone application 1
start from PCC 1
GUI visual reference 1
license key 1
licenses for prior releases 1
tasks (how to) 1
applying 1
obtaining 1
increasing 1
administering licenses with License Administrator 1
applying user count 1
determining total user count 1
displaying a specific license 1
displaying all applied licenses 1, 2
for prior releases 1
obtaining user count 1
starting License Administrator 1, 2
workgroup engine 1
fast user switching 1
client DSNs 1
engine DSNs 1
manual pages 1
MicroKernel Database Engine, starting and stopping 1
naming databases 1
user manual exclusions 1
changes/exclusions 1
utilities 1
utilities 1
btadmin 1
butil 1
clilcadm 1
mkded 1
Mkded, console mode 1
mkded, daemon mode 1
sqlmgr 1
sqlmgr, console mode 1
sqlmgr, daemon mode 1
Load balancing 1
database engine 1
NSS volumes before BSTART/MGRSTART 1
Local, defined 1
changing for table data file 1
Log on authority for service 1
troubleshooting 1
creating with Query Builder 1
OS vs DB 1
Lowest total cost of ownership 1
M
Manual pages 1
Map Root not supported 1
users for workgroup engine 1
MGRSTART, loading NSS volumes first 1
defined 1
Linux 1
NetWare 1
accessing Pervasive.SQL data using 1
limited to 256 columns 1
accessing Pervasive.SQL data using 1
NetWare to Windows server 1
where to find information 1
Windows server to NetWare 1
Mirroring, database 1
MKDE See MicroKernel Database Engine1
Mkded utility 1
console mode 1
daemon mode 1
data 1
table properties 1
O/S rights required 1
use of 1
N
in Create Database Wizard 1
Named databases 1
defined 1
dbmaint utility 1
from a Linux server 1
alternate way to apply a license key 1
btrieve.nlm and SQL engine 1
load dependencies 1
MicroKernel Database Engine, starting and stopping 1
migrating to Windows server 1
NSS volumes 1
slower on updates 1
nwmkde.nlm and btrieve.nlm required 1
ODBC and 1
reboot 5.x after installing Pervasive.SQL 1
unloading Pervasive.SQL 1
verifying 1
determining 1
troubleshooting 1
testing 1
New utilities 1
obtaining via e-mail 1
detecting 1
NSS volume support 1
Nulcnvwz.exe 1
modifying table definition and 1
restrictions for column 1
name of .exe 1
O
ODBC 1
concepts 1
interface, determining if used 1
odbc.ini 1
setting up on NetWare 1
OLE-DB provider 1
Online backup 1
format varies by computer 1
Online help 1
security vs DB security 1
troubleshooting access rights 1
changing 1
checking for 1
Pervasive Control Center 1
and SQL security 1
cannot use PCC to grant permissions for files with owner names 1
Ownership, lowest total cost of 1
P
troubleshooting wrong 1
NSS volumes slower on updates 1
Pervasive Control Center 1
accessing a remote server 1
databases 1
column attributes 1
Create Table Wizard 1
tables 1
Delete Database Wizard 1
databases 1
eliminating delay in Configuration 1
Export Wizard 1
Import Wizard 1
interpreting engine icons 1
overview 1
poll interval 1
registering a remote server 1
setting database security 1
SQL Data Manager 1
stopping and restarting services 1
turning security on/off and 1
viewing and modifying table properties 1
viewing database engines 1
wizards available 1
Pervasive Products and Services 1
Pervasive System Analyzer 1
name of .exe 1
advantages 1
benefits 1
client, defined 1
components of 1
explained 1
features 1
Server 1
server, defined 1
Workgroup 1
need to recreate DSNs 1
Pervasive.SQL utilities. See Utilities.1, 2
Pervasive_Admin security group 1
use with Active Directory 1, 2
Platform support 1
Preserving DDFs 1
modifying table definition and 1
Programming interfaces supported 1
determining network 1
PSA, see Pervasive System Analyzer1
psawizrd.exe 1
client and server compatibility 1
Q
Query timeout period 1
Questions, frequently asked 1
R
defined 1
determining 1
wrong when creating DDFs for old data 1
Redirected mapping not supported 1
listing 1
verifying 1
Referential integrity 1
checking 1
how to check integrity 1
Registering a remote engine in PCC 1
setting up on NetWare 1
database access 1
defined 1
Remove column button 1
Remove index button 1
Remove segment button 1
a remote engine from PCC 1
a table 1
databases 1
DSN 1
database inconsistencies 1
Replication 1
defined of 1
for SQL Relational Database Engine 1
troubleshooting client 1
adding a group 1
adding a user 1
administrative 1
required to create a database 1
for "this account" 1
on Linux 1
on NetWare 4.2, 5.x or 6.x 1
on Windows 2000 1
on Windows NT 1
if changed from system account 1
Row, defined 1
orphan,checking for 1
in trace mode 1
S
Scalable solution 1
converting v3.01 DDFs to current version 1
Scheduling events 1
Schema, defined 1
administrative rights 1
database 1
logging in as administrator 1, 2
OS login vs DB login 1
owner names vs SQL security 1
turning database security off 1
turning database security on 1
DSN not found in connection string 1
registering in PCC 1
troubleshooting network protocols 1
log in authority for "this account" 1
stopping Workgroup engine when using fast user switching 1
identifying level 1
starting and stopping with PCC 1
Database Security 1
setting up 1
database access on client 1
Shadowing, database 1
Shared files, troubleshooting 1
replaced by Pervasive System Analyzer 1
CREATE GROUP 1
CREATE USER 1
executing statements 1
GRANT 1
SQL Data Manager 1
active grid 1
aggregate functions 1
AVG (average) aggregate function 1
commenting lines 1
Count aggregate function 1
< 1
<= 1
<> 1
= 1
> 1
>= 1
BETWEEN 1
IN 1
IS NOT NULL 1
IS NULL 1
LIKE 1
NOT BETWEEN 1
NOT IN 1
NOT LIKE 1
getting started with 1
group by 1
main window GUI reference 1
About 1
Active Grid 1
Add Table command 1
Change Query Type command 1
Clear command 1
Close Database 1
Continue 1
Copy 1
Cut 1
Developer Center (Web) 1
Exit 1
File menu 1
Find 1
Find Next 1
Glossary 1
Grid Results tab 1
Group By command 1
How Do I? 1
Insert/Overtype indicator 1
Knowledge Base (Web) 1
New SQL Query command 1
Online Manuals (Web) 1
Open Database 1
Open SQL Query command 1
Page Setup 1
Paste 1
Print 1
Progress indicator 1
Properties 1
Query Builder 1
Query Builder Diagram command 1
Query Builder Grid command 1
Query Pane 1
Query Pane command 1
Replace 1
Results Grid 1
Rows fetched indicator 1
Run All SQL Statements command 1
Run Current SQL Statement in Grid command 1
Run Current SQL Statement in Text command 1
Save SQL Query As 1
Save SQL Query command 1
Search Documentation 1
Select All 1
Set Font command 1
SQL Statements 1
Stop command 1
Text Results tab 1
Title Bar 1
Topics 1
Undo 1
What's This? 1
MAX (maximum) aggregate function 1
MIN (minimum) aggregate function 1
panes 1
paste copied data into Excel 1
primary work areas 1
purpose 1
Query Builder 1
defined 1
logical AND 1
mixing use of statements 1
SQL statements to build with 1
Query Builder Diagram 1
behavior when no tables in Diagram 1
symbols used in table window 1
Query Builder Diagram GUI reference 1
Query Builder Grid 1
behavior when no tables in Query Builder Diagram 1
grid for DELETE statements 1
grid for INSERT statements 1
grid for SELECT statements 1
grid for UPDATE statements 1
grids specific to SQL statement types 1
Query Builder Grid GUI reference for DELETE 1
Column 1
Criteria 1
Or 1
Table 1
Query Builder Grid GUI reference for INSERT 1
Column 1
New Value 1
Query Builder Grid GUI reference for SELECT 1
Alias 1
Column 1
Criteria 1
Group by 1
Or 1
Order by 1
Result 1
Table 1
Query Builder Grid GUI reference for UPDATE 1
Column 1
Criteria 1
New Value 1
Or 1
Table 1
Query Pane 1
cursor movement within 1
records fetched indicator 1
restrictions 1
results tabs 1
scrolling 1
states of Grid Results 1
Text Results tab 1
SQL statements to use with 1
SUM aggregate function 1
add a Group By column to Query Builder Grid 1
add a table to Query Builder Diagram 1
build a DELETE statement with Query Builder 1
build a SELECT statement with Query Builder 1
build an INSERT statement with Query Builder 1
build an UPDATE statement with Query Builder 1
cancel (undo) typing actions in Query Pane 1
cancel an undo action (redo) in Query Pane 1
change data with Grid Results grid 1
clear results from Text Results tab 1
clear the contents of a row(s) on Query Builder Grid 1
close a database 1
continue running SQL statements that were stopped 1
copy text from Grid Results tab 1
copy text from Query Pane 1
copy text from Text Results tab 1
create an SQL query or script 1
cut or delete text from Query Pane 1
cut or delete text from Text Results tab 1
delete row(s) from Grid Results tab 1
delete row(s) on Query Builder Grid 1
display help 1
exit SQL DM 1
find text in Query Pane 1
identify machine and database currently open 1
insert a row into Query Builder Grid 1
joint tables in Query Builder Diagram 1
layout the printed page 1
move the cursor within Query Pane and run the SQL statement to which it moves 1
move the cursor within Query Pane without running any SQL statements 1
open a database 1
open an SQL script 1
paste within Query Pane 1
print the contents of Query Pane 1
remove a table from Query Builder Diagram 1
replace text in Query Pane 1
run a single SQL statement 1
run all SQL statements 1
save an SQL query as a script 1
select text in Query Pane 1
select text on Text Results tab 1
set default behavior for Grid Results grid 1
set Grid Results grid to allow changes to database data 1
set query timeout period 1
set query type for Query Builder 1
set SQL statement separator 1
set the font for grid results or text results 1
set the font for Query Pane 1
show or hide Query Builder Diagram 1
show or hide Query Builder Grid 1
show or hide Query Pane 1
start SQL DM as a stand-alone application 1
start SQL DM from PCC 1
stop running SQL statements 1
toggle insert/overtype mode 1
type a comment into Query Pane 1
work with grid results 1
work with text results 1
wrap text within Query Pane 1
SQL Engine Reference 1
creating with SQL Data Manager 1
SQL Relational Database Engine
defined 1
early file formats and 1
scheduler 1
setting up access on NetWare 1
SQL requester 1
SQL statement timeout period 1
commenting lines 1
use with SQL Data Manager 1
console mode 1
daemon mode 1
keeping Workgroup engine from autostarting 1
database engine 1
services with PCC 1
Status Codes and Messages 1
database engine 1
services with PCC 1
Workgroup engine under fast user switching 1
error code -4994 when creating 1
cross-platform 1
Switching, fast user 1
Symmetric Multiprocessing, see Multiple processors1
System account rights 1
T
changing location of data file 1
column attributes 1
defined 1
deleting 1
displaying information about 1
dropping 1
modifying 1
viewing 1
verifying against data file structure 1
viewing data from Table Designer 1
data types 1
Btrieve tab 1
columns tab 1
indexes tab 1
main window 1
statistics tab 1
linked mode 1
modes 1
null restrictions for column 1
purpose of 1
tabbed dialogs 1
access help 1
allow duplicates in index 1
change Btrieve column position 1
change column order 1
change location of table data file 1
change mode 1
delete Btrieve column 1
delete column 1
delete index 1
delete index segment 1
determine record length 1
discard all changes 1
display table information 1
display table statistics 1
identify active database and table 1
identify changes that have not been saved 1
insert column 1
insert index 1
insert index segment 1
save changes 1
set Btrieve column case sensitivity 1
set Btrieve column decimal places 1
set Btrieve column name 1
set Btrieve column size 1
set Btrieve column to allow nulls 1
set Btrieve column type 1
set column case sensitivity 1
set column collating sequence 1
set column data type 1
set column default 1
set column name 1
set column precision 1
set column scale 1
set column size 1
set column to allow or disallow nulls 1
specify index as modifiable 1
specify index sort column 1
specify index sort sequence 1
start from PCC 1
view table data 1
work with Btrieve data 1
work with columns 1
work with indexes 1
unlinked mode 1
adding 1
creating 1
Terminal Server 1
Btrieve usage 1
cell 1
client 1
column 1
database 1
database engine 1
engine 1
field 1
index 1
join 1
local 1
record 1
remote 1
requester 1
row 1
schema 1
table 1
value 1
your system 1
Timeout period for an SQL query 1
how to run in trace mode 1
with fast user switching 1
client DSN not available 1
disabled client requester 1
network outage 1
no server (engine) DSN available 1
OS permissions problems 1
server not accepting requests 1
server not running, not installed 1
wrong network protocol settings 1
U
troubleshooting 1
to data file with owner name 1
data files not affected 1
database engine 1
Pervasive.SQL on NetWare 1
slower on NetWare NSS volumes 1
can't get to data after 1
user count 1
where to find information 1
in Create Database Wizard 1
adding to a group 1
adding to database 1
deleting 1
administering with License Administrator 1
applying 1
determining total 1
how to apply 1
obtaining 1
troubleshooting expired license 1
workgroup engine 1
OS vs DB 1
troubleshooting wrong 1
act as part of the operating system 1
for "this account" 1
User switching 1
User's Guide 1
files with owner names and 1
types of for fast user switching 1
cannot use with files that have owner names 1
btadmin 1
butil 1
clilcadm 1
for Linux 1
License Administrator 1
mkded 1
console mode 1
daemon mode 1
new 1
sqlmgr 1
console mode 1
daemon mode 1
V
defined 1
new, data files not affected by installing 1
old, data files not affected by uninstalling 1
data 1
table properties 1
Viewing and modifying table properties 1
Viewing database engines in PCC 1
W
Web, scalable to 1
What's New 1
Database Server Engine, starting and stopping 1
Database Workgroup Engine, starting and stopping 1
fast user switching 1
running Workgroup engine with fast user switching 1
support for 1
tray icon with fast user switching 1
types of users for fast user switching 1
migrating to NetWare 1
name of .exe 1
name of .exe 1
name of .exe 1
name of .exe 1
name of .exe 1
name of .exe 1
name of .exe 1
name of .exe 1
name of .exe 1
Wizards in PCC 1
database access 1
keeping from autostarting 1
licensing 1
maximum users 1
simultaneous access 1
stopping under fast user switching 1
X
see Windows XP operating system1
replacement for 1
Z
Z-DBA 1
|
Pervasive Software, Inc. http://www.pervasive.com Voice: (512) 231-6000 Fax: (512) 231-6597 Pervasive Sales Support Documentation Feedback Contact Technical Support Pervasive DevTalk Forums Pervasive DeveloperZone |
| Prev Technical Support |
Contents |