TOC PREV NEXT

 

 

 

PointBase Developer's Guide
Table of Contents


Preface

Purpose
Audience
Release Notes
Document Feedback
Document Conventions Used in This Guide

Developer's Overview

JDBC and PointBase
SQL and PointBase
Your Application and PointBase
What's New With PointBase RDBMS?

PointBase JDBC Basic Tutorial

Refreshing the Sample Database
Making a Connection to PointBase
Creating and Executing Static JDBC Statement
Retrieving Row Values From Non-Scrollable Result Sets
Closing and Committing Objects

PointBase JDBC Advanced Tutorial

Creating and Executing a Dynamic JDBC Statement
Returning Scrollable Result Sets
Retrieving Information About the Result Set
Moving the Cursor in Scrollable Result Sets
Setting the Direction of the Cursor in Scrollable Result Sets
Flushing the Database Log
Performing Batch Operations
Retrieving Data From BLOB Columns
Retrieving Data From CLOB Columns
Creating Functions
Creating Stored Procedures

Basic SQL Data Objects

Data Objects Within the PointBase RDBMS
Database
User
Schema
Table
View
Column

SQL Data Types

Data Types
Data Conversions and Assignments

SQL Scalar and Aggregate Functions

SQL Scalar Numeric Functions
SQL Scalar Character String Functions
SQL Scalar Date/Time Functions
SQL Scalar CAST Function
SQL Scalar Routine Invocation
SQL Aggregate Functions
SQL Special Registers

Indexes and Constraints

Indexes
Keys
Constraints

Search Conditions and Predicates

Search Conditions
Predicates

Transactions and Locks

Transactions
Row Level Locking
Transaction Isolation Levels

Distributed Transactions

PointBase's Role in a DTP Environment
Java Transaction API (JTA)
JDBC API Extensions
Implementing javax.sql.XADataSource
Using PointBase in a DTP Environment
Mixing Global and Local Transactions
Unsupported in PointBase

SQL Security and Privileges

Granting and Revoking Privileges

Optimizer Usage in PointBase

Execution Plan
Commands for PointBase Commander

Appendix A: SQL Reference Guide

Conventions
Page Format Conventions
Syntax Conventions
Data Definition Language
CREATE SCHEMA
CREATE TABLE
CREATE VIEW
ALTER TABLE
CREATE USER
CREATE INDEX
CREATE FUNCTION
CREATE PROCEDURE
CREATE TRIGGER
Dropping SQL Objects
DROP INDEX
DROP FUNCTION or DROP PROCEDURE
DROP SCHEMA
DROP TABLE
DROP VIEW
DROP TRIGGER
DROP USER
Data Manipulation Language and Data Query Language
SELECT
INSERT
UPDATE
DELETE
Data Control Language
CALL
RETURN
SET assignment
SET PATH
SIGNAL
VALUES
Transaction Control
SAVEPOINT
COMMIT
RELEASE SAVEPOINT
ROLLBACK
SET DATALOG
START TRANSACTION ISOLATION LEVEL

Appendix B: PointBase Sample Database Application Code

Sample External Methods

Appendix C: Unsupported JDBC Methods in PointBase

Appendix D: Reserved Words

Appendix E: SQL Data Type Code


TOC PREV NEXT