Table of Contents
Purpose of This Document
Audience
How This Document Is Organized
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
Complete List of Reserved Words
Nonreserved Keywords
SYSALIASES
SYSCHECKS
SYSCOLUMNS
SYSCONGLOMERATES
SYSCONSTRAINTS
SYSDEPENDS
SYSERRORS
SYSFILES
SYSFOREIGNKEYS
SYSJDBCTYPEINFO
SYSKEYS
SYSSCHEMAS
SYSSTATEMENTS
SYSTABLES
SYSTRIGGERS
SYSVIEWS
Understanding SQLExceptions
SQLState and Error Message Reference
Common Exceptions
Getting a Complete List
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
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)
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
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
|