Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » UltraLiteJ » Using UltraLiteJ » Developing UltraLiteJ applications » Accessing and manipulating data using SQL

 

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.