BASIS DBMS and RDBMS

Full Text Searching/Indexing

Overview

Using FULLTEXT Files/Indices

SQL FULLTEXT Indices

FULLTEXT File Type

Managing Databases

• Overview

• Configuration

• Database Tabs

  • Information

  • Tables

  • Views

  • Procedures

  • Type Definitions

  • Sequences

  • Permissions

  • Roles

  • SQL

  • Query Analysis

Files

Introduction

Using the PREFIX Verb

Enabling, Disabling, and Changing Disks

Creating, Erasing, and Renaming Files

OPENing Files

Accessing Files/Positioning the Pointer

Reading Data

Writing Data

Removing Records

Locking Records (EXTRACT)

Locking Files (LOCK)

Journaled Files and Transactions

BBj File Type Comparison

STRING Files

PROGRAM Files

SERIAL Files

INDEXED Files

SORT/DIRECT Files

MKEYED Files

MKEYED Files - Using With String Templates

XKEYED Verb - Create XKEYED File

JKEYED Verb - Create Journaled File

VKEYED Verb

ESQL Overview

Directory Files

C-ISAM Files

SQL

• Introduction

• Command Execution

• Grammar

• Grammar - BBj

• Local Databases

• Concepts

• Supported SQL Data Manipulation for PRO/5 File Types

• BBj Data Server CREATE TABLE: Features and Usage

• BBj Data Server Group By

• BBj Data Server Having Clause

• BBj Data Server Outer Joins

• BBj Data Server Sequences/Auto Increments

• BBj Data Server Subqueries Using Nested SELECT Statements

• BBj Data Server Unions with the BASIS SQL Engine

• BBj Data Server Views

• Scalar Functions

  • Custom

  • Explicit Data Type Conversion

  • Numeric Functions

  • String Functions

  • System Functions

  • Time and Date Constants

  • Time and Date Functions

  • Other Functions

    • BIN() Function

    • DATE() Function

    • DEC() Function

    • DECRYPT() Function

    • ENCRYPT() Function

    • GLOBAL() Function

    • HEX() Function

    • HTA() Function

    • IFF() Function

    • INT() Function

    • JUL() Function

    • NUM() Function

    • PCK() Function

    • Select

    • STR() Function

    • String Concatenation

    • UPK() Function

  • Optimization Functions

    • SQL - Analyze Database

    • SQL - Analyze Table

PRO/5 Data Server

• PRO/5 Data Server Features

  • What is the PRO/5 Data Server?

  • Data Server Functionality and Limitations

  • Data Server Versions, Platforms, and Applicable Clients

  • User Limits and Licensing Considerations

  • Migrating to the Client/Server Model

  • Modifying Programs to Access the Data Server

• Configuration Files

• Windows NT Data Server

  • Pre-installation Checklist and Installation

  • Setting the Service Name and Port Number

  • Defining Network Access Settings

  • NT Data Server Security

  • Excluding Invalid Drives from the Search Path

  • Defining File Search Paths

  • Setting Advisory Locking for the Data Server

  • Configuring and Starting the Data Server

  • Stopping and Uninstalling the Data Server

• Novell NetWare Data Server

  • Pre-installation Checklist and Security Considerations

  • Installing the Data Server

  • Defining Network Access Settings

  • Defining File Search Paths

  • Starting the Data Server and Accessing Remote Files

  • Stopping and Uninstalling the Data Server

• UNIX Data Server

  • Pre-installation Checklist and UNIX Security Considerations

  • Installing the Data Server

  • Setting the Service Name and Port Number

  • Defining Network Access Settings

  • Defining File Search Paths

  • Modifying the UNIX .rhosts File

  • Starting and Stopping the Data Server Automatically

  • Command Line Options - UNIX Data Server

  • Uninstalling the Data Server

• Advanced Concepts

  • Using the SELECT Verb with the Data Server

  • Chaining Data Servers

• TCP/IP Stack

• Error Messages

  • Startup Errors

  • Log File Errors

  • Client Errors

• Reporting Problems

  • Before You Call

  • Contacting BASIS Technical Support

  • Other Sources of Data Server Information

Miscellaneous

Database Update API

Replication

Data Change Auditing

Linked Databases

Task Scheduling

BBj-only Data Dictionary - Overview