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