SQL-J Grammar Index
Page 1 of 1

SQL-J Grammar Index

A

ALTER STATEMENT statement
ALTER TABLE statement
AT ISOLATION clause
AVG (aggregate function)

B

BIT (data type)
BIT VARYING (data type)
BIT_LENGTH (function)
BOOLEAN (data type)
Boolean expression

C

CALL statement
CAST (function)
CHAR (data type)
CHAR_LENGTH (function)
CHARACTER_LENGTH (function)
Concatenation (function)
Conditional (?:) (expression)
CONSTRAINT clause
COUNT (*) (aggregate function)
COUNT (aggregate function)
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 (expression)
CURRENT_DATE (function)
CURRENT_TIME (function)
CURRENT_TIMESTAMP (function)
CURRENT_USER (function)

D

DATE (data type)
DECIMAL (data type)
DELETE statement
DISTINCT clause (part of SelectExpression)
DOUBLE PRECISION (data type)
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

E

EXECUTE STATEMENT statement
ExternalVirtualTable
EXTRACT (function)

F

Field Access (expression)
FLOAT (data type)
FOR UPDATE clause
FROM clause

G

GetCurrentConnection() (function)
GROUP BY clause

H

HAVING clause

I

INNER JOIN (expression)
INSERT statement
INSTANCEOF expressions
INTEGER (data type)

J

Java Data Types
JOIN Operation (expression)

L

LEFT OUTER JOIN (expression)
LOCK TABLE statement
LONG BINARY (data type)
LONG BIT VARYING (data type)
LONG NVARCHAR (data type)
LONG VARBINARY (data type)
LONG VARCHAR (data type)
LONGINT (data type)
LOWER (function)
LTRIM (function)

M

MAX (aggregate function)
Method Invocation (expression)
MIN (aggregate function)

N

NCHAR (data type)
NEW (expression)
NUMERIC (data type)
NVARCHAR (data type)

O

OCTET_LENGTH (function)
ORDER BY clause

P

PROPERTIES clause

R

REAL (data type)
RIGHT OUTER JOIN (expression)
RTRIM (function)
RUNTIMESTATISTICS() built-in function

S

ScalarSubquery (expression)
SELECT statement
SelectExpression
SESSION_USER (function)
SET CONSTRAINTS statement
SET RUNTIMESTATISTICS statement
SET SCHEMA statement
SET STATISTICS TIMING statement
SET TRANSACTION ISOLATION LEVEL statement
SET TRIGGERS statement
SMALLINT (data type)
SUBSTR (function)
SUBSTRING (function)
SUM (aggregate function)

T

TableExpression (expression)
TableSubquery (expression)
TIME (data type)
TIMESTAMP (data type)
TINYINT (data type)
TRIM (function)

U

UNION operator (part of Query)
UPDATE statement
UPPER (function)
USER (function)
User-Defined Data Types
User-DefinedAggregate

V

VALUES expression
VARCHAR (data type)

W

WHERE clause
WHERE CURRENT OF clause