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 | |
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 | |
DROP INDEX | |
DROP TABLE | |
INSERT | |
ROLLBACK | |
SELECT |
For a general description of the SELECT statement, see UltraLite SELECT statement. The following restrictions apply:
|
START SYNCHRONIZATION DELETE | |
STOP SYNCHRONIZATION DELETE | |
TRUNCATE TABLE | |
UPDATE |
For a general description of the SELECT statement, see UltraLite UPDATE statement. The JOIN clause is not supported. |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |