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 | |
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 | |
DROP INDEX | |
DROP PUBLICATION | See DROP PUBLICATION statement [UltraLite] [UltraLiteJ]. |
DROP SYNCHRONIZATION PROFILE | See DROP SYNCHRONIZATION PROFILE statement [UltraLite] [UltraLiteJ]. |
DROP TABLE | |
INSERT | |
ROLLBACK | |
SELECT |
For a general description of the SELECT statement, see SELECT statement [UltraLite] [UltraLiteJ]. The following restrictions apply:
|
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 | |
UPDATE |
For a general description of the SELECT statement, see UPDATE statement [UltraLite] [UltraLiteJ]. The JOIN clause is not supported. |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |