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 PUBLICATION See ALTER PUBLICATION statement [UltraLite][UltraLiteJ].
ALTER SYNCHRONIZATION PROFILE See ALTER SYNCHRONIZATION PROFILE statement [UltraLite] [UltraLiteJ].
ALTER TABLE

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

COMMIT

See COMMIT statement [UltraLite] [UltraLiteJ].

CREATE INDEX

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

CREATE PUBLICATION See CREATE PUBLICATION statement [UltraLite] [UltraLiteJ].
CREATE SYNCHRONIZATION PROFILE See CREATE SYNCHRONIZATION PROFILE statement [UltraLite] [UltraLiteJ].
CREATE TABLE

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

DELETE

See DELETE statement [UltraLite] [UltraLiteJ].

DROP INDEX

See DROP INDEX statement [UltraLite] [UltraLiteJ].

DROP PUBLICATION See DROP PUBLICATION statement [UltraLite] [UltraLiteJ].
DROP SYNCHRONIZATION PROFILE See DROP SYNCHRONIZATION PROFILE statement [UltraLite] [UltraLiteJ].
DROP TABLE

See DROP TABLE statement [UltraLite] [UltraLiteJ].

INSERT

See INSERT statement [UltraLite] [UltraLiteJ].

ROLLBACK

See ROLLBACK statement [UltraLite] [UltraLiteJ].

SELECT

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

The following restrictions apply:

  • The SQLCODE function is not supported.
  • The ACOS, ASIN, ATAN, ATAN2, and POWER mathematical functions are not supported.
SET OPTION See SET OPTION statement [UltraLite] [UltraLiteJ].
START SYNCHRONIZATION DELETE

See START SYNCHRONIZATION DELETE statement [UltraLite] [UltraLiteJ].

STOP SYNCHRONIZATION DELETE

See STOP SYNCHRONIZATION DELETE statement [UltraLite] [UltraLiteJ].

SYNCHRONIZE See SYNCHRONIZE statement [UltraLite] [UltraLiteJ].
TRUNCATE TABLE

See TRUNCATE TABLE statement [UltraLite] [UltraLiteJ].

UPDATE

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

The JOIN clause is not supported.