Supported SQL statements

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

SQL Statement Notes and Restrictions:
COMMIT

See UltraLite COMMIT statement.

ROLLBACK

See UltraLite ROLLBACK statement.

INSERT

See UltraLite INSERT statement.

UPDATE

See UltraLite UPDATE statement.

DELETE

See UltraLite DELETE statement.

SELECT

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

Following restrictions apply:

  • The HAVING clause is not supported.
  • The DISTINCT expression in an aggregate function is not supported. For example, UltraLiteJ supports COUNT(expression) but not COUNT (DISTINCT expression).
  • The SQLCODE function is not supported.
  • The ACOS, ASIN, ATAN, ATAN2, and POWER mathematical functions are not supported.
  • The CURRENT TIMESTAMP, CURRENT TIME, and CURRENT DATE functions are not supported. Use TODAY(*) or NOW(*) instead.
Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0