About This Document
Organization of This Guide
Database Access Methods
Transactional Programming with the MicroKernel Engine
Relational Programming
Appendixes
Overview of Zen Access Methods
Developer Quick Start
Choosing An Access Method
Database Connection Quick Reference
ADO.NET Connections
Sample ADO.NET DB Connection Code
JDBC Connections
Sample JDBC Connection Code
Java Class Library
Sample JCL Connection String
DSN-Less Connections
Example
ODBC Information
Other SQL Access Methods
JDBC
PDAC
Additional Resources for Application Developers
Conceptual Information
Reference Information
Online Developer Resources
Sample Code
Developing Applications for the MicroKernel Engine
MicroKernel Engine Environment
Documentation
Configuration Issues for MicroKernel Engine
MicroKernel Engine Fundamentals
Overview of the MicroKernel Engine
MicroKernel Engine Environment
Configuration Notes
Pages
Page Types
Page Size
Page Size Criteria
Large vs. Small Page Size
Factors To Consider When Determining Page Size
File Types
Standard Data Files
Data-Only Files
Key-Only Files
Large Files
Long File Names
Data Types
Key Attributes
Key Attributes Description
Segmentation
Duplicatability
Modifiability
Sort Order
Case Sensitivity
Null Value
Legacy Null
True Null Indexes
Rules for True Null Keys
NIS Values
Sorting of True Null Values
Linked Duplicate Keys and True Nulls
Repeating Duplicate Keys and True Nulls
Unique Keys and True Nulls
Nonmodifiable Keys and True Nulls
Get Operations and True Nulls
Distinct True Nulls
Multi-Segmented True Null Keys
Excluding Records from an Index
Use of Null Indicator Segment in Extended Operations.
True Nulls and the SQL Engine
True Nulls and Extended Operations
Alternate Collating Sequences
User-Defined ACS
International Sort Rules
Key Specification
Key Specification Block
Key Flag Values
Limitations and Side Effects
Database URIs
Syntax
Parameter Precedence
Precedence Examples
Special Characters
Examples
Remarks
Examples
IPv6
Double-Byte Character Support
Record Length
Data Integrity
Record Locks
Transactions
Exclusive Transactions
Concurrent Transactions
Exclusive vs. Concurrent
Transaction Durability
System Data
Shadow Paging
Backing Up Your Files
Event Logging
Performance Enhancement
System Transactions
Preparation Phase
Writing Phase
Frequency of System Transactions
Less Frequent
More Frequent
Memory Management
Page Preallocation
Extended Operations
Disk Usage
Free Space List
Index Balancing
Data Compression
Blank Truncation
Designing a Database
Understanding Data Files
Creating a Data File
Data Layout
Key Attributes
File Attributes
Creating File and Key Specification Structures
Sample Data Buffer for File and Key Specifications Using BTRV Entry Point
Creating a File with Page Level Compression
Calling the Create Operation
Create Operation
Create Index Operation
Calculating the Logical Record Length
Choosing a Page Size
Optimum Page Size For Minimizing Disk Space
Record Overhead in Bytes Without Record Compression
Record Overhead in Bytes With Record Compression
Page Overhead in Bytes
Physical Record Length Worksheet
Optimum Page Size Example
Minimum Page Size
Estimating File Size
Formula and Derivative Steps
Page Sizes of Special Pages by File Format
Optimizing Your Database
Duplicatable Keys
Linked-Duplicatable Keys
Repeating-Duplicatable Keys
Linked vs. Repeating
Page Preallocation
Blank Truncation
Record Compression
Index Balancing
Variable-tail Allocation Tables
Key-Only Files
Setting Up Security
Owner Names
Exclusive Mode
SQL Security
Language Interfaces Modules
Interface Modules Overview
Programming Notes
C/C++
Interface Modules
BTRAPI.C
BTRAPI.H
BTRVEXID.H
BTRCONST.H
BTITYPES.H
BTRSAMP.C
Programming Requirements
Delphi
DOS (Btrieve)
Interface Modules
BTRAPI.C
BTRAPI.H
BTRCONST.H
BTITYPES.H
Pascal
Source Modules
BBTRAPID.PAS
BTRCONST.PAS
BTRSAMPD.PAS
Visual Basic
Interface Libraries
Overview of Interface Libraries
Linux
Distributing Zen Applications
Distribution Rules for Zen
Installing Zen with your Application
Working with Records
Sequence of Operations
Accessing Records
Accessing Records by Physical Location
Physical Currency
Step Operations
Accessing Records by Key Value
Logical Currency
NCC Insert Operation
Get Operations
Reading Variable-Length Records
Get Equal Operation in C
Get Equal Operation in Visual BASIC
Accessing Records by Chunks
Intrarecord Currency
Chunk Operations
Inserting and Updating Records
Ensuring Reliability in Mission-Critical Inserts and Updates
Inserting Nonduplicatable Keys
Inserting and Updating Variable-Length Records
Insert Operation
Reading and Updating Fixed-length Portions
Updating Nonmodifiable Keys
No-Currency-Change (NCC) Operations
Multirecord Operations
Terminology
Background
Validation
Optimization
Examples
Performance Tips
Connectors
Reject Count
Adding and Dropping Keys
Supporting Multiple Clients
Btrieve Clients
Assumptions
Action Codes
Conflict Codes
Passive Concurrency
Record Locking
User Transactions
Locks
Explicit Record Locks in a Nontransactional Environment
Single-Record Locks
Multiple-Record Locks
When a Record Has Already Been Locked
Record Locks in Concurrent Transactions
Implicit Record Locks
Example Without Implicit Locks
Implicit Locks
File Locks
Examples of Multiple Concurrency Control
Example 1
Example 2
Concurrency Control for Multiple Position Blocks
Multiple Position Blocks
ClientID Parameter
Debugging Your Btrieve Application
Trace Files
MicroKernel Trace File of a BUTIL STAT Call
Indirect Chunk Operations in Client-Server Environments
Engine Shutdowns and Connection Resets
Reducing Wasted Space in Files
Btrieve API Programming
Fundamentals of Btrieve API Programming
Btrieve API Flow Chart
Inserting Records
Updating Records
Deleting Records
Visual Basic Notes
Delphi Notes
Starting a Zen Application
Adding Zen Source Modules
Btrieve API Code Samples
Creating a File
Sample Code
Visual Basic (Creating a File)
Delphi (Creating a File)
C/C++ (Creating a File)
Sample Structures (Creating a File)
Visual Basic (Creating a File) – Sample Structure
Delphi (Creating a File) – Sample Structure
C/C++ (Creating a File)– Sample Structure
Inserting Records
Sample Code
Visual Basic (Inserting Records)
Delphi (Inserting Records)
C/C++ (Inserting Records)
Sample Structures (Inserting Records)
Visual Basic (Inserting Records) – Sample Structure
Delphi (Inserting Records) – Sample Structure
C/C++(Inserting Records) – Sample Structure
Updating Records
Sample Code
Visual Basic (Updating Records)
Delphi (Updating Records)
C/C++ (Updating Records)
Sample Structures (Updating Records)
Visual Basic (Updating Records) – Sample Structure
Delphi (Updating Records) – Sample Structure
C/C++ (Updating Records) – Sample Structure
Performing Step Operations
Sample Code
Delphi (Step Operations)
C/C++ (Step Operations)
Sample Structures
Delphi (Step Operations) – Sample Structure
C/C++ (Step Operations) – Sample Structure
Performing Get Operations
Sample Code
Visual Basic (Get Operations)
Delphi (Get Operations)
C/C++ (Get Operations)
Sample Structures (Get Operations)
Visual Basic (Get Operations) – Sample Structure
Delphi (Get Operations) – Sample Structure
C/C++ (Get Operations) – Sample Structure
Chunking, BLOBs, and Variable-Length Records
Sample Code
Visual Basic (Chunking/BLOBs/Variable-Length Records)
Sample Structures (Chunking/BLOBs/Variable-Length Records)
Visual Basic (Chunking/BLOBs/Variable-Length Records) – Sample Structure
Working with Segmented Indexes
Sample Code
Visual Basic (Segmented Indexes)
Delphi (Segmented Indexes)
C/C++ (Segmented Indexes)
Declarations of Btrieve API Functions for Visual Basic
Creating a Database
Named Databases
Bound Databases
Creating Database Components
Naming Conventions
Unique Names
Valid Characters
Maximum Name Lengths
Case Sensitivity
Creating a Data Dictionary
Creating Tables
Aliases
Creating Columns
Creating Indexes
Index Segments
Index Attributes
Relational Database Design
Overview of Database Design
Stages of Design
Conceptual Design
Logical Design
Table Relationships
Normalization
First Normal Form
Second Normal Form
Third Normal Form
Keys
Physical Design
Inserting and Deleting Data
Overview of Inserting and Deleting Data
Inserting Values
Transaction Processing
Deleting Data
Dropping Indexes
Dropping Columns
Dropping Tables
Dropping an Entire Database
Modifying Data
Overview of Modifying Data
Modifying Tables
Setting Default Values
Using UPDATE
Retrieving Data
Overview of Retrieving Data
Views
Features of Views
Temporary and Stored Views
Read-Only Tables in Views
Mergeable Views
Selection Lists
Sorted and Grouped Rows
Joins
Joining Tables with Other Tables
Joining Views with Tables
Types of Joins
Equal Joins
Nonequal Joins
Cartesian Product Joins
Self Joins
Left, Right, Full Outer Joins
Subqueries
Subquery Limitations
Correlated Subqueries
Restriction Clauses
Restriction Clause Operators
Boolean Operators
Condition Operators
Expression Operators
Restriction Clause Examples
OR and Equal To (=)
IN
LIKE
Functions
Aggregate Functions
Arguments to Aggregate Functions
Aggregate Function Rules
Scalar Functions
Storing Logic
Stored Procedures
Stored Procedure and Positioned Update
Declaring Stored Procedures
Invoking Stored Procedures
Deleting Stored Procedures
SQL Variable Statements
Procedure-Owned Variables
Assignment Statements
SQL Control Statements
Compound Statement
IF Statement
LEAVE Statement
LOOP Statement
WHILE Statement
SQL Triggers
Timing and Ordering of Triggers
Specifying the Triggered Action Time
Specifying Trigger Order
Defining the Trigger Action
Managing Data
Overview of Managing Data
Defining Relationships Among Tables
Referential Integrity Definitions
Keys
Primary Keys
Creating Primary Keys
Dropping Primary Keys
Changing Primary Keys
Foreign Keys
Creating Foreign Keys in Existing Tables
Creating Foreign Keys When Creating a Table
Dropping Foreign Keys
Referential Constraints
Referential Integrity Rules
Insert Rule
Update Rule
Delete Rule
Anomaly on Delete-Connected Cycles
Anomaly on Multiple Paths
Referential Integrity in the Sample Database
Creating the Course Table
Adding a Primary Key to Course
Creating the Student Table with Referential Constraints
Administering Database Security
Understanding Database Rights
Establishing Database Security
Enabling Security
Creating User Groups and Users
Creating User Groups
Creating Users
Granting Rights
Granting Rights to the PUBLIC Group
Granting Rights to User Groups
Granting Rights to Users
Dropping Users and User Groups
Revoking Rights
Disabling Security
Retrieving Information about Database Security
Concurrency Controls
Transaction Processing
Starting and Ending Transactions
Using Savepoints to Nest Transactions
Special Considerations
Isolation Levels
Exclusive Isolation Level (SQL_TXN_SERIALIZABLE)
Cursor Stability Isolation Level (SQL_TXN_READ_COMMITTED)
Transactions and Isolation Levels
Avoiding Deadlock Conditions
Deadlock Conditions under Exclusive Isolation Level
Deadlock Conditions under Cursor Stability Isolation Level
Passive Control
Atomicity in Zen Databases
Transaction Control in Procedures
A. Sample Collations Using International Sorting Rules
German Sample Collations
Unsorted Data
Sorted Data
Spanish Sample Collations
Unsorted Data
Sorted Data
French Sample Collations
Unsorted Data
Sorted Data
B. Sample Database Tables and Referential Integrity
Overview of the Demodata Sample Database
Structure of the Demodata Sample Database
Assumptions
Entity Relationships
Example of Referential Integrity in the Demodata Database
Table Design of the Demodata Sample Database
BILLING Table
CLASS Table
COURSE Table
DEPT Table
ENROLLS Table
FACULTY Table
PERSON Table
ROOM Table
STUDENT Table
TUITION Table
About This Document
Overview of Zen Access Methods
Developer Quick Start
Developing Applications for the MicroKernel Engine
MicroKernel Engine Fundamentals
Designing a Database
Language Interfaces Modules
Interface Libraries
Working with Records
Supporting Multiple Clients
Debugging Your Btrieve Application
Btrieve API Programming
Creating a Database
Relational Database Design
Inserting and Deleting Data
Modifying Data
Retrieving Data
Storing Logic
Managing Data
A. Sample Collations Using International Sorting Rules
B. Sample Database Tables and Referential Integrity
Developer Reference
>
Getting Started
>
Programmer's Guide
>
About This Document
Developer Reference
>
Getting Started
>
Programmer's Guide
>
About This Document
>
Organization of This Guide
Developer Reference
>
Getting Started
>
Programmer's Guide
>
About This Document
>
Organization of This Guide
>
Database Access Methods
Developer Reference
>
Getting Started
>
Programmer's Guide
>
About This Document
>
Organization of This Guide
>
Transactional Programming with the MicroKernel Engine
Developer Reference
>
Getting Started
>
Programmer's Guide
>
About This Document
>
Organization of This Guide
>
Relational Programming
Developer Reference
>
Getting Started
>
Programmer's Guide
>
About This Document
>
Organization of This Guide
>
Appendixes
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Overview of Zen Access Methods
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Developer Quick Start
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Developer Quick Start
>
Choosing An Access Method
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Developer Quick Start
>
Database Connection Quick Reference
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Developer Quick Start
>
Database Connection Quick Reference
>
ADO.NET Connections
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Developer Quick Start
>
Database Connection Quick Reference
>
ADO.NET Connections
>
Sample ADO.NET DB Connection Code
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Developer Quick Start
>
Database Connection Quick Reference
>
JDBC Connections
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Developer Quick Start
>
Database Connection Quick Reference
>
JDBC Connections
>
Sample JDBC Connection Code
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Developer Quick Start
>
Database Connection Quick Reference
>
Java Class Library
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Developer Quick Start
>
Database Connection Quick Reference
>
Java Class Library
>
Sample JCL Connection String
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Developer Quick Start
>
Database Connection Quick Reference
>
DSN-Less Connections
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Developer Quick Start
>
Database Connection Quick Reference
>
DSN-Less Connections
>
Example
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Developer Quick Start
>
ODBC Information
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Developer Quick Start
>
ODBC Information
>
Other SQL Access Methods
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Developer Quick Start
>
ODBC Information
>
Other SQL Access Methods
>
JDBC
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Developer Quick Start
>
ODBC Information
>
Other SQL Access Methods
>
PDAC
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Developer Quick Start
>
Additional Resources for Application Developers
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Developer Quick Start
>
Additional Resources for Application Developers
>
Conceptual Information
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Developer Quick Start
>
Additional Resources for Application Developers
>
Reference Information
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Developer Quick Start
>
Additional Resources for Application Developers
>
Online Developer Resources
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Developer Quick Start
>
Additional Resources for Application Developers
>
Sample Code
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Developing Applications for the MicroKernel Engine
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Developing Applications for the MicroKernel Engine
>
MicroKernel Engine Environment
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Developing Applications for the MicroKernel Engine
>
MicroKernel Engine Environment
>
Documentation
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Developing Applications for the MicroKernel Engine
>
Configuration Issues for MicroKernel Engine
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Overview of the MicroKernel Engine
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Overview of the MicroKernel Engine
>
MicroKernel Engine Environment
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Overview of the MicroKernel Engine
>
MicroKernel Engine Environment
>
Configuration Notes
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Pages
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Pages
>
Page Types
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Pages
>
Page Size
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Pages
>
Page Size
>
Page Size Criteria
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Pages
>
Page Size
>
Large vs. Small Page Size
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Pages
>
Page Size
>
Large vs. Small Page Size
>
Factors To Consider When Determining Page Size
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
File Types
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
File Types
>
Standard Data Files
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
File Types
>
Data-Only Files
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
File Types
>
Key-Only Files
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
File Types
>
Large Files
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
File Types
>
Long File Names
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Data Types
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Key Attributes
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Key Attributes
>
Key Attributes Description
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Key Attributes
>
Key Attributes Description
>
Segmentation
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Key Attributes
>
Key Attributes Description
>
Duplicatability
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Key Attributes
>
Key Attributes Description
>
Modifiability
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Key Attributes
>
Key Attributes Description
>
Sort Order
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Key Attributes
>
Key Attributes Description
>
Case Sensitivity
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Key Attributes
>
Key Attributes Description
>
Null Value
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Key Attributes
>
Key Attributes Description
>
Null Value
>
Legacy Null
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Key Attributes
>
Key Attributes Description
>
Null Value
>
True Null Indexes
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Key Attributes
>
Key Attributes Description
>
Null Value
>
Rules for True Null Keys
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Key Attributes
>
Key Attributes Description
>
Null Value
>
NIS Values
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Key Attributes
>
Key Attributes Description
>
Null Value
>
Sorting of True Null Values
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Key Attributes
>
Key Attributes Description
>
Null Value
>
Linked Duplicate Keys and True Nulls
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Key Attributes
>
Key Attributes Description
>
Null Value
>
Repeating Duplicate Keys and True Nulls
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Key Attributes
>
Key Attributes Description
>
Null Value
>
Unique Keys and True Nulls
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Key Attributes
>
Key Attributes Description
>
Null Value
>
Nonmodifiable Keys and True Nulls
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Key Attributes
>
Key Attributes Description
>
Null Value
>
Get Operations and True Nulls
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Key Attributes
>
Key Attributes Description
>
Null Value
>
Distinct True Nulls
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Key Attributes
>
Key Attributes Description
>
Null Value
>
Multi-Segmented True Null Keys
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Key Attributes
>
Key Attributes Description
>
Null Value
>
Excluding Records from an Index
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Key Attributes
>
Key Attributes Description
>
Null Value
>
Use of Null Indicator Segment in Extended Operations.
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Key Attributes
>
Key Attributes Description
>
Null Value
>
True Nulls and the SQL Engine
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Key Attributes
>
Key Attributes Description
>
Null Value
>
True Nulls and Extended Operations
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Key Attributes
>
Key Attributes Description
>
Alternate Collating Sequences
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Key Attributes
>
Key Attributes Description
>
User-Defined ACS
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Key Attributes
>
Key Attributes Description
>
International Sort Rules
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Key Attributes
>
Key Specification
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Key Attributes
>
Key Specification
>
Key Specification Block
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Key Attributes
>
Key Specification
>
Key Flag Values
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Key Attributes
>
Key Specification
>
Limitations and Side Effects
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Database URIs
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Database URIs
>
Syntax
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Database URIs
>
Parameter Precedence
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Database URIs
>
Parameter Precedence
>
Precedence Examples
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Database URIs
>
Special Characters
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Database URIs
>
Special Characters
>
Examples
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Database URIs
>
Remarks
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Database URIs
>
Examples
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Database URIs
>
IPv6
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Double-Byte Character Support
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Record Length
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Data Integrity
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Data Integrity
>
Record Locks
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Data Integrity
>
Transactions
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Data Integrity
>
Transactions
>
Exclusive Transactions
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Data Integrity
>
Transactions
>
Concurrent Transactions
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Data Integrity
>
Transactions
>
Exclusive vs. Concurrent
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Data Integrity
>
Transaction Durability
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Data Integrity
>
System Data
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Data Integrity
>
Shadow Paging
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Data Integrity
>
Backing Up Your Files
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Event Logging
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Performance Enhancement
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Performance Enhancement
>
System Transactions
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Performance Enhancement
>
System Transactions
>
Preparation Phase
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Performance Enhancement
>
System Transactions
>
Writing Phase
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Performance Enhancement
>
System Transactions
>
Frequency of System Transactions
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Performance Enhancement
>
System Transactions
>
Frequency of System Transactions
>
Less Frequent
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Performance Enhancement
>
System Transactions
>
Frequency of System Transactions
>
More Frequent
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Performance Enhancement
>
Memory Management
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Performance Enhancement
>
Page Preallocation
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Performance Enhancement
>
Extended Operations
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Disk Usage
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Disk Usage
>
Free Space List
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Disk Usage
>
Index Balancing
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Disk Usage
>
Data Compression
Developer Reference
>
Getting Started
>
Programmer's Guide
>
MicroKernel Engine Fundamentals
>
Disk Usage
>
Blank Truncation
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Designing a Database
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Designing a Database
>
Understanding Data Files
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Designing a Database
>
Creating a Data File
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Designing a Database
>
Creating a Data File
>
Data Layout
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Designing a Database
>
Creating a Data File
>
Data Layout
>
Key Attributes
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Designing a Database
>
Creating a Data File
>
Data Layout
>
File Attributes
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Designing a Database
>
Creating a Data File
>
Creating File and Key Specification Structures
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Designing a Database
>
Creating a Data File
>
Creating File and Key Specification Structures
>
Sample Data Buffer for File and Key Specifications Using BTRV Entry Point
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Designing a Database
>
Creating a Data File
>
Creating a File with Page Level Compression
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Designing a Database
>
Creating a Data File
>
Calling the Create Operation
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Designing a Database
>
Creating a Data File
>
Calling the Create Operation
>
Create Operation
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Designing a Database
>
Creating a Data File
>
Create Index Operation
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Designing a Database
>
Calculating the Logical Record Length
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Designing a Database
>
Choosing a Page Size
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Designing a Database
>
Choosing a Page Size
>
Optimum Page Size For Minimizing Disk Space
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Designing a Database
>
Choosing a Page Size
>
Optimum Page Size For Minimizing Disk Space
>
Record Overhead in Bytes Without Record Compression
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Designing a Database
>
Choosing a Page Size
>
Optimum Page Size For Minimizing Disk Space
>
Record Overhead in Bytes With Record Compression
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Designing a Database
>
Choosing a Page Size
>
Optimum Page Size For Minimizing Disk Space
>
Page Overhead in Bytes
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Designing a Database
>
Choosing a Page Size
>
Optimum Page Size For Minimizing Disk Space
>
Physical Record Length Worksheet
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Designing a Database
>
Choosing a Page Size
>
Optimum Page Size For Minimizing Disk Space
>
Optimum Page Size Example
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Designing a Database
>
Choosing a Page Size
>
Minimum Page Size
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Designing a Database
>
Estimating File Size
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Designing a Database
>
Estimating File Size
>
Formula and Derivative Steps
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Designing a Database
>
Estimating File Size
>
Formula and Derivative Steps
>
Page Sizes of Special Pages by File Format
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Designing a Database
>
Optimizing Your Database
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Designing a Database
>
Optimizing Your Database
>
Duplicatable Keys
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Designing a Database
>
Optimizing Your Database
>
Duplicatable Keys
>
Linked-Duplicatable Keys
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Designing a Database
>
Optimizing Your Database
>
Duplicatable Keys
>
Repeating-Duplicatable Keys
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Designing a Database
>
Optimizing Your Database
>
Duplicatable Keys
>
Linked vs. Repeating
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Designing a Database
>
Optimizing Your Database
>
Page Preallocation
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Designing a Database
>
Optimizing Your Database
>
Blank Truncation
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Designing a Database
>
Optimizing Your Database
>
Record Compression
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Designing a Database
>
Optimizing Your Database
>
Index Balancing
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Designing a Database
>
Optimizing Your Database
>
Variable-tail Allocation Tables
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Designing a Database
>
Optimizing Your Database
>
Key-Only Files
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Designing a Database
>
Setting Up Security
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Designing a Database
>
Setting Up Security
>
Owner Names
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Designing a Database
>
Setting Up Security
>
Exclusive Mode
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Designing a Database
>
Setting Up Security
>
SQL Security
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Language Interfaces Modules
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Language Interfaces Modules
>
Interface Modules Overview
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Language Interfaces Modules
>
Interface Modules Overview
>
Programming Notes
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Language Interfaces Modules
>
C/C++
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Language Interfaces Modules
>
C/C++
>
Interface Modules
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Language Interfaces Modules
>
C/C++
>
Interface Modules
>
BTRAPI.C
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Language Interfaces Modules
>
C/C++
>
Interface Modules
>
BTRAPI.H
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Language Interfaces Modules
>
C/C++
>
Interface Modules
>
BTRVEXID.H
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Language Interfaces Modules
>
C/C++
>
Interface Modules
>
BTRCONST.H
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Language Interfaces Modules
>
C/C++
>
Interface Modules
>
BTITYPES.H
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Language Interfaces Modules
>
C/C++
>
Interface Modules
>
BTRSAMP.C
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Language Interfaces Modules
>
C/C++
>
Programming Requirements
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Language Interfaces Modules
>
Delphi
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Language Interfaces Modules
>
DOS (Btrieve)
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Language Interfaces Modules
>
DOS (Btrieve)
>
Interface Modules
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Language Interfaces Modules
>
DOS (Btrieve)
>
Interface Modules
>
BTRAPI.C
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Language Interfaces Modules
>
DOS (Btrieve)
>
Interface Modules
>
BTRAPI.H
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Language Interfaces Modules
>
DOS (Btrieve)
>
Interface Modules
>
BTRCONST.H
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Language Interfaces Modules
>
DOS (Btrieve)
>
Interface Modules
>
BTITYPES.H
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Language Interfaces Modules
>
Pascal
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Language Interfaces Modules
>
Pascal
>
Source Modules
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Language Interfaces Modules
>
Pascal
>
Source Modules
>
BBTRAPID.PAS
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Language Interfaces Modules
>
Pascal
>
Source Modules
>
BTRCONST.PAS
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Language Interfaces Modules
>
Pascal
>
Source Modules
>
BTRSAMPD.PAS
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Language Interfaces Modules
>
Visual Basic
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Interface Libraries
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Interface Libraries
>
Overview of Interface Libraries
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Interface Libraries
>
Overview of Interface Libraries
>
Linux
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Interface Libraries
>
Distributing Zen Applications
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Interface Libraries
>
Distributing Zen Applications
>
Distribution Rules for Zen
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Interface Libraries
>
Distributing Zen Applications
>
Installing Zen with your Application
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Working with Records
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Working with Records
>
Sequence of Operations
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Working with Records
>
Accessing Records
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Working with Records
>
Accessing Records
>
Accessing Records by Physical Location
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Working with Records
>
Accessing Records
>
Accessing Records by Physical Location
>
Physical Currency
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Working with Records
>
Accessing Records
>
Accessing Records by Physical Location
>
Step Operations
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Working with Records
>
Accessing Records
>
Accessing Records by Key Value
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Working with Records
>
Accessing Records
>
Accessing Records by Key Value
>
Logical Currency
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Working with Records
>
Accessing Records
>
Accessing Records by Key Value
>
Logical Currency
>
NCC Insert Operation
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Working with Records
>
Accessing Records
>
Accessing Records by Key Value
>
Get Operations
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Working with Records
>
Accessing Records
>
Reading Variable-Length Records
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Working with Records
>
Accessing Records
>
Reading Variable-Length Records
>
Get Equal Operation in C
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Working with Records
>
Accessing Records
>
Reading Variable-Length Records
>
Get Equal Operation in Visual BASIC
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Working with Records
>
Accessing Records
>
Accessing Records by Chunks
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Working with Records
>
Accessing Records
>
Accessing Records by Chunks
>
Intrarecord Currency
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Working with Records
>
Accessing Records
>
Accessing Records by Chunks
>
Chunk Operations
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Working with Records
>
Inserting and Updating Records
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Working with Records
>
Inserting and Updating Records
>
Ensuring Reliability in Mission-Critical Inserts and Updates
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Working with Records
>
Inserting and Updating Records
>
Inserting Nonduplicatable Keys
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Working with Records
>
Inserting and Updating Records
>
Inserting and Updating Variable-Length Records
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Working with Records
>
Inserting and Updating Records
>
Inserting and Updating Variable-Length Records
>
Insert Operation
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Working with Records
>
Inserting and Updating Records
>
Reading and Updating Fixed-length Portions
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Working with Records
>
Inserting and Updating Records
>
Updating Nonmodifiable Keys
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Working with Records
>
Inserting and Updating Records
>
No-Currency-Change (NCC) Operations
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Working with Records
>
Multirecord Operations
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Working with Records
>
Multirecord Operations
>
Terminology
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Working with Records
>
Multirecord Operations
>
Background
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Working with Records
>
Multirecord Operations
>
Validation
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Working with Records
>
Multirecord Operations
>
Optimization
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Working with Records
>
Multirecord Operations
>
Optimization
>
Examples
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Working with Records
>
Multirecord Operations
>
Performance Tips
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Working with Records
>
Multirecord Operations
>
Performance Tips
>
Connectors
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Working with Records
>
Multirecord Operations
>
Performance Tips
>
Reject Count
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Working with Records
>
Adding and Dropping Keys
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Supporting Multiple Clients
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Supporting Multiple Clients
>
Btrieve Clients
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Supporting Multiple Clients
>
Btrieve Clients
>
Assumptions
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Supporting Multiple Clients
>
Btrieve Clients
>
Action Codes
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Supporting Multiple Clients
>
Btrieve Clients
>
Conflict Codes
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Supporting Multiple Clients
>
Passive Concurrency
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Supporting Multiple Clients
>
Record Locking
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Supporting Multiple Clients
>
User Transactions
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Supporting Multiple Clients
>
User Transactions
>
Locks
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Supporting Multiple Clients
>
User Transactions
>
Locks
>
Explicit Record Locks in a Nontransactional Environment
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Supporting Multiple Clients
>
User Transactions
>
Locks
>
Single-Record Locks
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Supporting Multiple Clients
>
User Transactions
>
Locks
>
Multiple-Record Locks
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Supporting Multiple Clients
>
User Transactions
>
Locks
>
When a Record Has Already Been Locked
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Supporting Multiple Clients
>
User Transactions
>
Record Locks in Concurrent Transactions
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Supporting Multiple Clients
>
User Transactions
>
Record Locks in Concurrent Transactions
>
Implicit Record Locks
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Supporting Multiple Clients
>
User Transactions
>
Record Locks in Concurrent Transactions
>
Implicit Record Locks
>
Example Without Implicit Locks
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Supporting Multiple Clients
>
User Transactions
>
Implicit Locks
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Supporting Multiple Clients
>
User Transactions
>
File Locks
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Supporting Multiple Clients
>
Examples of Multiple Concurrency Control
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Supporting Multiple Clients
>
Examples of Multiple Concurrency Control
>
Example 1
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Supporting Multiple Clients
>
Examples of Multiple Concurrency Control
>
Example 2
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Supporting Multiple Clients
>
Concurrency Control for Multiple Position Blocks
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Supporting Multiple Clients
>
Multiple Position Blocks
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Supporting Multiple Clients
>
ClientID Parameter
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Debugging Your Btrieve Application
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Debugging Your Btrieve Application
>
Trace Files
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Debugging Your Btrieve Application
>
Trace Files
>
MicroKernel Trace File of a BUTIL STAT Call
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Debugging Your Btrieve Application
>
Indirect Chunk Operations in Client-Server Environments
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Debugging Your Btrieve Application
>
Engine Shutdowns and Connection Resets
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Debugging Your Btrieve Application
>
Reducing Wasted Space in Files
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Fundamentals of Btrieve API Programming
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Fundamentals of Btrieve API Programming
>
Btrieve API Flow Chart
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Fundamentals of Btrieve API Programming
>
Btrieve API Flow Chart
>
Inserting Records
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Fundamentals of Btrieve API Programming
>
Btrieve API Flow Chart
>
Updating Records
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Fundamentals of Btrieve API Programming
>
Btrieve API Flow Chart
>
Deleting Records
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Visual Basic Notes
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Delphi Notes
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Starting a Zen Application
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Starting a Zen Application
>
Adding Zen Source Modules
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Creating a File
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Creating a File
>
Sample Code
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Creating a File
>
Sample Code
>
Visual Basic (Creating a File)
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Creating a File
>
Sample Code
>
Delphi (Creating a File)
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Creating a File
>
Sample Code
>
C/C++ (Creating a File)
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Creating a File
>
Sample Structures (Creating a File)
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Creating a File
>
Sample Structures (Creating a File)
>
Visual Basic (Creating a File) – Sample Structure
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Creating a File
>
Sample Structures (Creating a File)
>
Delphi (Creating a File) – Sample Structure
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Creating a File
>
Sample Structures (Creating a File)
>
C/C++ (Creating a File)– Sample Structure
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Inserting Records
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Inserting Records
>
Sample Code
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Inserting Records
>
Sample Code
>
Visual Basic (Inserting Records)
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Inserting Records
>
Sample Code
>
Delphi (Inserting Records)
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Inserting Records
>
Sample Code
>
C/C++ (Inserting Records)
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Inserting Records
>
Sample Structures (Inserting Records)
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Inserting Records
>
Sample Structures (Inserting Records)
>
Visual Basic (Inserting Records) – Sample Structure
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Inserting Records
>
Sample Structures (Inserting Records)
>
Delphi (Inserting Records) – Sample Structure
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Inserting Records
>
Sample Structures (Inserting Records)
>
C/C++(Inserting Records) – Sample Structure
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Updating Records
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Updating Records
>
Sample Code
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Updating Records
>
Sample Code
>
Visual Basic (Updating Records)
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Updating Records
>
Sample Code
>
Delphi (Updating Records)
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Updating Records
>
Sample Code
>
C/C++ (Updating Records)
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Updating Records
>
Sample Structures (Updating Records)
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Updating Records
>
Sample Structures (Updating Records)
>
Visual Basic (Updating Records) – Sample Structure
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Updating Records
>
Sample Structures (Updating Records)
>
Delphi (Updating Records) – Sample Structure
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Updating Records
>
Sample Structures (Updating Records)
>
C/C++ (Updating Records) – Sample Structure
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Performing Step Operations
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Performing Step Operations
>
Sample Code
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Performing Step Operations
>
Sample Code
>
Delphi (Step Operations)
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Performing Step Operations
>
Sample Code
>
C/C++ (Step Operations)
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Performing Step Operations
>
Sample Structures
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Performing Step Operations
>
Sample Structures
>
Delphi (Step Operations) – Sample Structure
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Performing Step Operations
>
Sample Structures
>
C/C++ (Step Operations) – Sample Structure
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Performing Get Operations
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Performing Get Operations
>
Sample Code
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Performing Get Operations
>
Sample Code
>
Visual Basic (Get Operations)
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Performing Get Operations
>
Sample Code
>
Delphi (Get Operations)
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Performing Get Operations
>
Sample Code
>
C/C++ (Get Operations)
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Performing Get Operations
>
Sample Structures (Get Operations)
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Performing Get Operations
>
Sample Structures (Get Operations)
>
Visual Basic (Get Operations) – Sample Structure
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Performing Get Operations
>
Sample Structures (Get Operations)
>
Delphi (Get Operations) – Sample Structure
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Performing Get Operations
>
Sample Structures (Get Operations)
>
C/C++ (Get Operations) – Sample Structure
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Chunking, BLOBs, and Variable-Length Records
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Chunking, BLOBs, and Variable-Length Records
>
Sample Code
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Chunking, BLOBs, and Variable-Length Records
>
Sample Code
>
Visual Basic (Chunking/BLOBs/Variable-Length Records)
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Chunking, BLOBs, and Variable-Length Records
>
Sample Structures (Chunking/BLOBs/Variable-Length Records)
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Chunking, BLOBs, and Variable-Length Records
>
Sample Structures (Chunking/BLOBs/Variable-Length Records)
>
Visual Basic (Chunking/BLOBs/Variable-Length Records) – Sample Structure
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Working with Segmented Indexes
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Working with Segmented Indexes
>
Sample Code
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Working with Segmented Indexes
>
Sample Code
>
Visual Basic (Segmented Indexes)
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Working with Segmented Indexes
>
Sample Code
>
Delphi (Segmented Indexes)
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Btrieve API Code Samples
>
Working with Segmented Indexes
>
Sample Code
>
C/C++ (Segmented Indexes)
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Btrieve API Programming
>
Declarations of Btrieve API Functions for Visual Basic
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Creating a Database
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Creating a Database
>
Named Databases
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Creating a Database
>
Bound Databases
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Creating a Database
>
Creating Database Components
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Creating a Database
>
Naming Conventions
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Creating a Database
>
Naming Conventions
>
Unique Names
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Creating a Database
>
Naming Conventions
>
Valid Characters
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Creating a Database
>
Naming Conventions
>
Maximum Name Lengths
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Creating a Database
>
Naming Conventions
>
Case Sensitivity
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Creating a Database
>
Creating a Data Dictionary
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Creating a Database
>
Creating Tables
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Creating a Database
>
Creating Tables
>
Aliases
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Creating a Database
>
Creating Columns
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Creating a Database
>
Creating Indexes
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Creating a Database
>
Creating Indexes
>
Index Segments
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Creating a Database
>
Creating Indexes
>
Index Attributes
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Relational Database Design
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Relational Database Design
>
Overview of Database Design
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Relational Database Design
>
Stages of Design
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Relational Database Design
>
Stages of Design
>
Conceptual Design
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Relational Database Design
>
Stages of Design
>
Logical Design
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Relational Database Design
>
Stages of Design
>
Logical Design
>
Table Relationships
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Relational Database Design
>
Stages of Design
>
Logical Design
>
Normalization
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Relational Database Design
>
Stages of Design
>
Logical Design
>
Normalization
>
First Normal Form
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Relational Database Design
>
Stages of Design
>
Logical Design
>
Normalization
>
Second Normal Form
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Relational Database Design
>
Stages of Design
>
Logical Design
>
Normalization
>
Third Normal Form
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Relational Database Design
>
Stages of Design
>
Logical Design
>
Keys
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Relational Database Design
>
Stages of Design
>
Physical Design
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Inserting and Deleting Data
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Inserting and Deleting Data
>
Overview of Inserting and Deleting Data
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Inserting and Deleting Data
>
Inserting Values
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Inserting and Deleting Data
>
Transaction Processing
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Inserting and Deleting Data
>
Deleting Data
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Inserting and Deleting Data
>
Dropping Indexes
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Inserting and Deleting Data
>
Dropping Columns
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Inserting and Deleting Data
>
Dropping Tables
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Inserting and Deleting Data
>
Dropping an Entire Database
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Modifying Data
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Modifying Data
>
Overview of Modifying Data
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Modifying Data
>
Modifying Tables
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Modifying Data
>
Setting Default Values
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Modifying Data
>
Using UPDATE
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Retrieving Data
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Retrieving Data
>
Overview of Retrieving Data
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Retrieving Data
>
Views
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Retrieving Data
>
Views
>
Features of Views
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Retrieving Data
>
Views
>
Temporary and Stored Views
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Retrieving Data
>
Views
>
Read-Only Tables in Views
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Retrieving Data
>
Views
>
Mergeable Views
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Retrieving Data
>
Selection Lists
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Retrieving Data
>
Sorted and Grouped Rows
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Retrieving Data
>
Joins
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Retrieving Data
>
Joins
>
Joining Tables with Other Tables
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Retrieving Data
>
Joins
>
Joining Views with Tables
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Retrieving Data
>
Joins
>
Types of Joins
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Retrieving Data
>
Joins
>
Types of Joins
>
Equal Joins
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Retrieving Data
>
Joins
>
Types of Joins
>
Nonequal Joins
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Retrieving Data
>
Joins
>
Types of Joins
>
Cartesian Product Joins
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Retrieving Data
>
Joins
>
Types of Joins
>
Self Joins
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Retrieving Data
>
Joins
>
Types of Joins
>
Left, Right, Full Outer Joins
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Retrieving Data
>
Subqueries
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Retrieving Data
>
Subqueries
>
Subquery Limitations
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Retrieving Data
>
Subqueries
>
Correlated Subqueries
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Retrieving Data
>
Restriction Clauses
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Retrieving Data
>
Restriction Clauses
>
Restriction Clause Operators
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Retrieving Data
>
Restriction Clauses
>
Restriction Clause Operators
>
Boolean Operators
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Retrieving Data
>
Restriction Clauses
>
Restriction Clause Operators
>
Condition Operators
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Retrieving Data
>
Restriction Clauses
>
Restriction Clause Operators
>
Expression Operators
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Retrieving Data
>
Restriction Clauses
>
Restriction Clause Examples
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Retrieving Data
>
Restriction Clauses
>
Restriction Clause Examples
>
OR and Equal To (=)
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Retrieving Data
>
Restriction Clauses
>
Restriction Clause Examples
>
IN
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Retrieving Data
>
Restriction Clauses
>
Restriction Clause Examples
>
LIKE
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Retrieving Data
>
Functions
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Retrieving Data
>
Functions
>
Aggregate Functions
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Retrieving Data
>
Functions
>
Arguments to Aggregate Functions
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Retrieving Data
>
Functions
>
Aggregate Function Rules
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Retrieving Data
>
Functions
>
Scalar Functions
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Storing Logic
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Storing Logic
>
Stored Procedures
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Storing Logic
>
Stored Procedures
>
Stored Procedure and Positioned Update
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Storing Logic
>
Stored Procedures
>
Declaring Stored Procedures
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Storing Logic
>
Stored Procedures
>
Invoking Stored Procedures
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Storing Logic
>
Stored Procedures
>
Deleting Stored Procedures
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Storing Logic
>
SQL Variable Statements
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Storing Logic
>
SQL Variable Statements
>
Procedure-Owned Variables
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Storing Logic
>
SQL Variable Statements
>
Assignment Statements
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Storing Logic
>
SQL Control Statements
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Storing Logic
>
SQL Control Statements
>
Compound Statement
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Storing Logic
>
SQL Control Statements
>
IF Statement
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Storing Logic
>
SQL Control Statements
>
LEAVE Statement
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Storing Logic
>
SQL Control Statements
>
LOOP Statement
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Storing Logic
>
SQL Control Statements
>
WHILE Statement
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Storing Logic
>
SQL Triggers
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Storing Logic
>
SQL Triggers
>
Timing and Ordering of Triggers
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Storing Logic
>
SQL Triggers
>
Timing and Ordering of Triggers
>
Specifying the Triggered Action Time
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Storing Logic
>
SQL Triggers
>
Timing and Ordering of Triggers
>
Specifying Trigger Order
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Storing Logic
>
SQL Triggers
>
Defining the Trigger Action
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Overview of Managing Data
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Defining Relationships Among Tables
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Defining Relationships Among Tables
>
Referential Integrity Definitions
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Keys
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Keys
>
Primary Keys
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Keys
>
Primary Keys
>
Creating Primary Keys
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Keys
>
Primary Keys
>
Dropping Primary Keys
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Keys
>
Primary Keys
>
Changing Primary Keys
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Keys
>
Foreign Keys
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Keys
>
Foreign Keys
>
Creating Foreign Keys in Existing Tables
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Keys
>
Foreign Keys
>
Creating Foreign Keys When Creating a Table
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Keys
>
Foreign Keys
>
Dropping Foreign Keys
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Referential Constraints
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Referential Constraints
>
Referential Integrity Rules
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Referential Constraints
>
Referential Integrity Rules
>
Insert Rule
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Referential Constraints
>
Referential Integrity Rules
>
Update Rule
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Referential Constraints
>
Referential Integrity Rules
>
Delete Rule
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Referential Constraints
>
Referential Integrity Rules
>
Delete Rule
>
Anomaly on Delete-Connected Cycles
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Referential Constraints
>
Referential Integrity Rules
>
Delete Rule
>
Anomaly on Multiple Paths
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Referential Integrity in the Sample Database
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Referential Integrity in the Sample Database
>
Creating the Course Table
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Referential Integrity in the Sample Database
>
Adding a Primary Key to Course
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Referential Integrity in the Sample Database
>
Creating the Student Table with Referential Constraints
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Administering Database Security
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Administering Database Security
>
Understanding Database Rights
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Administering Database Security
>
Establishing Database Security
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Administering Database Security
>
Enabling Security
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Administering Database Security
>
Creating User Groups and Users
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Administering Database Security
>
Creating User Groups and Users
>
Creating User Groups
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Administering Database Security
>
Creating User Groups and Users
>
Creating Users
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Administering Database Security
>
Granting Rights
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Administering Database Security
>
Granting Rights
>
Granting Rights to the PUBLIC Group
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Administering Database Security
>
Granting Rights
>
Granting Rights to User Groups
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Administering Database Security
>
Granting Rights
>
Granting Rights to Users
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Administering Database Security
>
Dropping Users and User Groups
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Administering Database Security
>
Revoking Rights
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Administering Database Security
>
Disabling Security
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Administering Database Security
>
Retrieving Information about Database Security
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Concurrency Controls
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Concurrency Controls
>
Transaction Processing
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Concurrency Controls
>
Starting and Ending Transactions
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Concurrency Controls
>
Using Savepoints to Nest Transactions
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Concurrency Controls
>
Special Considerations
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Concurrency Controls
>
Isolation Levels
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Concurrency Controls
>
Isolation Levels
>
Exclusive Isolation Level (SQL_TXN_SERIALIZABLE)
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Concurrency Controls
>
Isolation Levels
>
Cursor Stability Isolation Level (SQL_TXN_READ_COMMITTED)
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Concurrency Controls
>
Isolation Levels
>
Transactions and Isolation Levels
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Concurrency Controls
>
Isolation Levels
>
Avoiding Deadlock Conditions
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Concurrency Controls
>
Isolation Levels
>
Avoiding Deadlock Conditions
>
Deadlock Conditions under Exclusive Isolation Level
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Concurrency Controls
>
Isolation Levels
>
Avoiding Deadlock Conditions
>
Deadlock Conditions under Cursor Stability Isolation Level
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Concurrency Controls
>
Passive Control
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Atomicity in Zen Databases
Developer Reference
>
Getting Started
>
Programmer's Guide
>
Managing Data
>
Atomicity in Zen Databases
>
Transaction Control in Procedures
Developer Reference
>
Getting Started
>
Programmer's Guide
>
A. Sample Collations Using International Sorting Rules
Developer Reference
>
Getting Started
>
Programmer's Guide
>
A. Sample Collations Using International Sorting Rules
>
German Sample Collations
Developer Reference
>
Getting Started
>
Programmer's Guide
>
A. Sample Collations Using International Sorting Rules
>
German Sample Collations
>
Unsorted Data
Developer Reference
>
Getting Started
>
Programmer's Guide
>
A. Sample Collations Using International Sorting Rules
>
German Sample Collations
>
Sorted Data
Developer Reference
>
Getting Started
>
Programmer's Guide
>
A. Sample Collations Using International Sorting Rules
>
Spanish Sample Collations
Developer Reference
>
Getting Started
>
Programmer's Guide
>
A. Sample Collations Using International Sorting Rules
>
Spanish Sample Collations
>
Unsorted Data
Developer Reference
>
Getting Started
>
Programmer's Guide
>
A. Sample Collations Using International Sorting Rules
>
Spanish Sample Collations
>
Sorted Data
Developer Reference
>
Getting Started
>
Programmer's Guide
>
A. Sample Collations Using International Sorting Rules
>
French Sample Collations
Developer Reference
>
Getting Started
>
Programmer's Guide
>
A. Sample Collations Using International Sorting Rules
>
French Sample Collations
>
Unsorted Data
Developer Reference
>
Getting Started
>
Programmer's Guide
>
A. Sample Collations Using International Sorting Rules
>
French Sample Collations
>
Sorted Data
Developer Reference
>
Getting Started
>
Programmer's Guide
>
B. Sample Database Tables and Referential Integrity
Developer Reference
>
Getting Started
>
Programmer's Guide
>
B. Sample Database Tables and Referential Integrity
>
Overview of the Demodata Sample Database
Developer Reference
>
Getting Started
>
Programmer's Guide
>
B. Sample Database Tables and Referential Integrity
>
Structure of the Demodata Sample Database
Developer Reference
>
Getting Started
>
Programmer's Guide
>
B. Sample Database Tables and Referential Integrity
>
Structure of the Demodata Sample Database
>
Assumptions
Developer Reference
>
Getting Started
>
Programmer's Guide
>
B. Sample Database Tables and Referential Integrity
>
Structure of the Demodata Sample Database
>
Entity Relationships
Developer Reference
>
Getting Started
>
Programmer's Guide
>
B. Sample Database Tables and Referential Integrity
>
Example of Referential Integrity in the Demodata Database
Developer Reference
>
Getting Started
>
Programmer's Guide
>
B. Sample Database Tables and Referential Integrity
>
Table Design of the Demodata Sample Database
Developer Reference
>
Getting Started
>
Programmer's Guide
>
B. Sample Database Tables and Referential Integrity
>
Table Design of the Demodata Sample Database
>
BILLING Table
Developer Reference
>
Getting Started
>
Programmer's Guide
>
B. Sample Database Tables and Referential Integrity
>
Table Design of the Demodata Sample Database
>
CLASS Table
Developer Reference
>
Getting Started
>
Programmer's Guide
>
B. Sample Database Tables and Referential Integrity
>
Table Design of the Demodata Sample Database
>
COURSE Table
Developer Reference
>
Getting Started
>
Programmer's Guide
>
B. Sample Database Tables and Referential Integrity
>
Table Design of the Demodata Sample Database
>
DEPT Table
Developer Reference
>
Getting Started
>
Programmer's Guide
>
B. Sample Database Tables and Referential Integrity
>
Table Design of the Demodata Sample Database
>
ENROLLS Table
Developer Reference
>
Getting Started
>
Programmer's Guide
>
B. Sample Database Tables and Referential Integrity
>
Table Design of the Demodata Sample Database
>
FACULTY Table
Developer Reference
>
Getting Started
>
Programmer's Guide
>
B. Sample Database Tables and Referential Integrity
>
Table Design of the Demodata Sample Database
>
PERSON Table
Developer Reference
>
Getting Started
>
Programmer's Guide
>
B. Sample Database Tables and Referential Integrity
>
Table Design of the Demodata Sample Database
>
ROOM Table
Developer Reference
>
Getting Started
>
Programmer's Guide
>
B. Sample Database Tables and Referential Integrity
>
Table Design of the Demodata Sample Database
>
STUDENT Table
Developer Reference
>
Getting Started
>
Programmer's Guide
>
B. Sample Database Tables and Referential Integrity
>
Table Design of the Demodata Sample Database
>
TUITION Table