Table of Contents
Page 1 of 1

Table of Contents

SQL-J Grammar Index

About This Document

Purpose of This Document

Audience

How This Document Is Organized

1 SQL-J Language Reference

Capitalization and Special Characters

SQL-J Identifiers

Rules for Both SQL92Identifiers and JavaIdentifiers

SQL92Identifier

Qualifying Dictionary Objects

SchemaName

TableName

ViewName

CorrelationName

ColumnName

SimpleColumnName

IndexName

ConstraintName

CursorName

MethodAlias

ClassAlias

AggregateName

StatementName

TriggerName

AuthorizationIdentifier

JarName

JavaIdentifier

JavaClassName

JavaMethodName

JavaFieldName

Statements

Interaction with the Dependency System

Interaction with the Java Data Types

Statement List

ALTER STATEMENT statement

ALTER TABLE statement

AT ISOLATION clause

CALL statement

CONSTRAINT clause

CREATE Statements

CREATE AGGREGATE statement

CREATE CLASS ALIAS statement

CREATE INDEX statement

CREATE METHOD ALIAS statement

CREATE SCHEMA statement

CREATE STATEMENT statement

CREATE TABLE statement

CREATE TRIGGER statement

CREATE VIEW statement

CROSS JOIN

DELETE statement

DROP Statements

DROP AGGREGATE statement

DROP CLASS ALIAS statement

DROP INDEX statement

DROP METHOD ALIAS statement

DROP SCHEMA statement

DROP STATEMENT statement

DROP TABLE statement

DROP TRIGGER statement

DROP VIEW statement

EXECUTE STATEMENT statement

ExternalVirtualTable

FOR UPDATE clause

FROM clause

GROUP BY clause

HAVING clause

INNER JOIN

INSERT statement

JOIN operation

LEFT OUTER JOIN

LOCK TABLE statement

ORDER BY clause

PROPERTIES clause

Query

RIGHT OUTER JOIN

ScalarSubquery

SelectExpression

SELECT statement

SET Statements

SET CONSTRAINTS statement

SET RUNTIMESTATISTICS statement

SET SCHEMA statement

SET STATISTICS TIMING statement

SET TRANSACTION ISOLATION LEVEL statement

SET TRIGGERS statement

TableExpression

TableSubquery

UPDATE statement

VALUES expression

WHERE clause

WHERE CURRENT OF clause

Built-In Functions

Standard Built-In Functions

Aggregates (Set Functions)

AVG

BIT_LENGTH

CAST

CHAR_LENGTH, CHARACTER_LENGTH

Concatenation

Conditional (?:)

COUNT

COUNT(*)

CURRENT_DATE

CURRENT_TIME

CURRENT_TIMESTAMP

CURRENT_USER

EXTRACT

LOWER

LTRIM

MAX

MIN

OCTET_LENGTH

RTRIM

RUNTIMESTATISTICS()

SESSION_USER

SUBSTRING

SUBSTR

SUM

TRIM

UPPER

USER

User-Defined Aggregate

Data Types

Built-In Type Overview

SQL-J Types, Java Types, and JDBC Types

Numeric Types

Numeric Type Overview

Numeric Type Promotion in Expressions

Storing Values of One Numeric Data Type in Columns of Another Numeric Data Type

Scale for Decimal Arithmetic

Implicit Type Conversion of String Types

Implicit Conversions from Strings to Other Built-In Data Types

Implicit Conversion to Strings from Other Built-In Data Types

Limitations on Implicit Conversions from or to String Types

Comparing Booleans with Numeric Types and Assigning Numeric Types to Booleans

Data Types and Comparison, Sorting, and Ordering

International String Data Types

The Types

Locale-Specific Collating Sequences

Comparisons to Ordinary String Data Types

Locale-Sensitive String Functions

International String Data Types and Conversions to Other Types

Date/Time Types

Numerical Types

BIT

BIT VARYING

BOOLEAN

CHAR

DATE

DECIMAL

DOUBLE PRECISION

FLOAT

INTEGER

LONGINT

LONG NVARCHAR

LONG VARBINARY, LONG BIT VARYING, LONG BINARY

LONG VARCHAR

NCHAR

NUMERIC

NVARCHAR

REAL

SMALLINT

TIME

TIMESTAMP

TINYINT

VARCHAR

Java Data Types (User-Defined Data Types)

SQL-J Expressions

Expression Precedence

Boolean expression

Dynamic Parameters

Java Expressions

Method Invocation

Field Access

INSTANCEOF Expression

NEW

GETCURRENTCONNECTION()

SQL-J and Java Type Correspondence

Column Values and Type Correspondence

SQL-J to Java Type Correspondence

Java to SQL-J Type Correspondence

Method Resolution and Type Correspondence

2 SQL-J Keywords and Reserved Words

Complete List of Reserved Words

Nonreserved Keywords

3 Cloudscape 3.6 Support for SQL-92 Features

4 Cloudscape System Tables

SYSALIASES

SYSCHECKS

SYSCOLUMNS

SYSCONGLOMERATES

SYSCONSTRAINTS

SYSDEPENDS

SYSERRORS

SYSFILES

SYSFOREIGNKEYS

SYSJDBCTYPEINFO

SYSKEYS

SYSSCHEMAS

SYSSTATEMENTS

SYSTABLES

SYSTRIGGERS

SYSVIEWS

5 Cloudscape Exception Messages and SQL States

Understanding SQLExceptions

SQLState and Error Message Reference

Common Exceptions

Getting a Complete List

6 JDBC Reference

Core JDK 1.1.x java.sql Classes, Interfaces, and Methods

java.sql.Driver

java.sql.DriverManager.getConnection

java.sql.Driver.getPropertyInfo

java.sql.Connection

java.sql.DatabaseMetaData

java.sql.Statement

java.sql.PreparedStatement

java.sql.CallableStatement

java.sql.ResultSet

java.sql.ResultSetMetaData

java.sql.SQLException

java.sql.SQLWarning

java.sql.Types

JDBC 2.0-Only Features

java.sql.Blob and java.sql.Clob

java.sql.Connection

java.sql.ResultSet

java.sql.Statement

java.sql.PreparedStatement

java.sql.CallableStatement

java.sql.DatabaseMetaData

java.sql.ResultSetMetaData

java.sql.BatchUpdateException

JDBC Escape Syntax

call

d

oj

t

ts

7 Database Connection URL Attributes

autocommit=false

bootPassword=key

create=true

current=true

databaseName=nameofDatabase

dataEncryption=true

encryptionProvider=providerName

encryptionAlgorithm=algorithm

locale=ll_CC

logDevice=logDirectoryPath

password=userPassword

shutdown=true

unicode=false

upgrade=true

user=userName

(no attributes)

8 J2EE Compliance: Java Transaction API and javax.sql Extensions

J2EE Overview

JVM and Libraries for J2EE Features

The JTA API

Notes on Product Behavior

Recovered Global Transactions

XAConnections and User Names and Passwords

javax.sql: JDBC Extensions

Appendix A Cloudscape API

Stand-Alone Tools and Utilities

Core Classes

Boot Classes

Data Source Classes

SQL-J Extensions

Types Used in System Tables

Other Types

SQLException-Related

User-Throwable

Interfaces for User-Defined Aggregates

VTIs

Miscellaneous Utilities and Interfaces

Index