Copyright: Copyright © 1999-2001 Pervasive Software Inc.


Contents
Pervasive.SQL Control Center

The Pervasive.SQL Control Center provides a single user interface for all the Pervasive.SQL utilities. For general information on using the Control Center, see Using the Pervasive.SQL Control Center.

For complete documentation, see Pervasive.SQL V8 Documentation

The following utilities and wizards are included with Pervasive.SQL V8. Use the following links to display help on a particular topic.

Utilities

Table Designer

Function Executor

Maintenance

Monitor

Rebuild

License Administrator

Configuration Utility

SQL Data Manager

ODBC Administrator (Windows utility)

Wizards

Pervasive System Analyzer

Create Database

Drop Database

Check Database Consistency

Create Table

Drop Table

Import Data

Export Data

Null Conversion


HIDD_CREATEDB_STARTPAGE


HIDD_CREATEDB_LOGINPAGE


HIDD_CREATEDB_NAME_LOCATION_PAGE


HIDD_CREATEDB_COMPLETE_PAGE


HIDD_CREATEDB_FINISH_PAGE


HIDD_CHECKDB_START_PAGE


HIDD_CHECKDB_LOGIN_PAGE


HIDD_CHECKDB_TYPE_SELECTION_PAGE


HIDD_CHECKDB_CONSISTANCY_PAGE


HIDD_CHECKDB_REFERENTIAL_PAGE


HIDD_CHECKDB_COMPLETE_PAGE


HIDD_CHECKDB_FINISH_PAGE


HIDD_DROPDB_START_PAGE


HIDD_DROPDB_LOGIN_PAGE


HIDD_DROPDB_SELECT_NAME1_PAGE


HIDD_DROPDB_SELECT_NAME2_PAGE


HIDD_DROPDB_COMPLETE_PAGE


HIDD_DROPDB_FINISH_PAGE


Namespace Server

The namespace server consists of a tree of objects related to that particular server. The tree of objects can be opened or expanded to reveal more detail. Examples of objects include engines, databases, lists of tables, users and engine configuration settings.


Connecting to an Engine

You can connect to other networked Pervasive.SQL 2000 engines through the Pervasive Control Center.

1  Right-click on the Pervasive.SQL 2000 Engines namespace node and select New Engine Registration. You are prompted to enter a computer name. You can also browse the network tree to select a machine to which you can connect.

2  To disconnect from a machine, select Disconnect Engine from the Action menu after right-clicking on the machine in the namespace.


Namespace Views
Namespace View

The namespace view contains the tree of objects pertinent to that particular engine. These objects can be opened or expanded to reveal more detail. Examples of objects include engines, databases, lists of tables, users and engine configuration settings. Each object in the tree, when selected, has it’s own unique set of functionalities and it’s own set of tools to enable these functionalities.


Namespace Tables

The namespace tables contain all the tables related to a particular database. You can view properties or manipulate these tables individually by selecting the table and right-click to display the available options.

To change the table structure, you can invoke the Table Designer utility from Pervasive Control Center.  To do this, right-click on a table and select Tasks | Edit Table Design.  See Table Designer Help for more information.


HIDD_CREATE_VIEW


HIDD_CREATE_USER_GENERAL


HIDD_CREATE_USER_PERMISSIONS


Add External Tools

1 From the Tools menu, select External Tools. The External Tools dialog box appears.

2 Click on the Add... button to include a new external tool in the Tools list.

3 Enter the location of the external tool that you wish to add. You may browse to a file by pressing the "..." button. Optionally, you may also specify parameters that should be included when running the command.

4 When done, click Ok.

5 Click Close in the External Tools dialog box.


HIDD_DROPTAB_STARTPAGE


HIDD_DROPTAB_LOGIN_PAGE


HIDD_DROPTAB_SELECTTAB_PAGE


HIDD_DROPTAB_COMPLETE_PAGE


HIDD_DROPTAB_FINISH_PAGE


HIDD_CREATETAB_START_PAGE


HIDD_CREATETAB_LOGIN_PAGE


HIDD_CREATETAB_TABLENAME_PAGE


HIDD_CREATETAB_COLUMN_PAGE


HIDD_CREATETAB_INDEX_PAGE


HIDD_CREATETAB_SQL_SCRIPT_PAGE


HIDD_CREATETAB_COMPLETE_PAGE


HIDD_CREATETAB_FINISH_PAGE


HIDD_SNIFFER_SELECT_DATAFILE_PAGE


HIDD_SNIFFER_VIEW_COLUMNS


HIDD_SNIFFER_DESIGN_PAGE


HIDD_SNIFFER_SPLIT_DIALOG


Namespace View

The namespace view contains all the views related to a particular database. You can view properties or manipulate these views by selecting the view and right-click to display the available options.

For more information, see the entries for CREATE VIEW in the Pervasive.SQL documentation.


Users
Namespace Users

The namespace users contain all the authorized users and groups that have access to a particular database. You can view properties or manipulate the groups or users, as long as you have administrator rights to do so. You can access groups and users by selecting the user or group and right-click to display the available options.


Create Stored Procedures
Create New Stored Procedure

The Pervasive Control Center lets you create stored procedures directly from the namespace area. To create a new stored procedure or view an existing stored procedure, select the stored procedure and right-click to display the available options.

For more information, see the entries for CREATE PROCEDURE in the Pervasive.SQL documentation.


Create New View

The Pervasive Control Center lets you create views directly from the namespace area. To create a new view or to look at an existing view, select the view and right-click to display the available options.

For more information, see the entries for CREATE VIEW in the Pervasive.SQL documentation.


Create New User

The Pervasive Control Center lets you create groups and assign users directly from the namespace area. To create a new group or user, select the group and right-click to display the available options.


Security
Setting Database Security

To set or disable database security follow these steps:

1  Right-click on the database's namespace node and click Properties in the shortcut menu.

2  Select the Security pane in the Database properties dialog box.

3  Since security is on, the pane will include a check box entry to turn security off. Select it and press OK to turn off security.


Create User Permissions

1  Click on the Permissions tab of the New User (or New Group) dialog box to enter the specific operations that this user (or Group) is entitled to perform on the database.