Supported SQL statements

Some SQL statements that are supported by UltraLite are not supported by UltraLiteJ. The following is a complete list of SQL statements supported by UltraLiteJ:

SQL Statement Notes and Restrictions:
ALTER TABLE

See UltraLite ALTER TABLE statement. MAX HASH SIZE is not supported.

COMMIT

See UltraLite COMMIT statement.

CREATE INDEX

See UltraLite CREATE INDEX statement. MAX HASH SIZE is not supported.

CREATE TABLE

See UltraLite CREATE TABLE statement. MAX HASH SIZE is not supported.

DELETE

See UltraLite DELETE statement.

DROP INDEX

See UltraLite DROP INDEX statement.

DROP TABLE

See UltraLite DROP TABLE statement.

INSERT

See UltraLite INSERT statement.

ROLLBACK

See UltraLite ROLLBACK statement.

SELECT

For a general description of the SELECT statement, see UltraLite SELECT statement.

The following restrictions apply:

  • The SQLCODE function is not supported.
  • The ACOS, ASIN, ATAN, ATAN2, and POWER mathematical functions are not supported.
START SYNCHRONIZATION DELETE

See UltraLite START SYNCHRONIZATION DELETE statement.

STOP SYNCHRONIZATION DELETE

See UltraLite STOP SYNCHRONIZATION DELETE statement.

TRUNCATE TABLE

See UltraLite TRUNCATE TABLE statement.

UPDATE

For a general description of the SELECT statement, see UltraLite UPDATE statement.

The JOIN clause is not supported.