Open SQL for Java is based on entry level SQL, specified in ISO/IEC 9075, third edition 1992-11-01, Information technology – Database languages – SQL.
In addition to Entry level SQL, the following Intermediate SQL constructs are also supported:
...
· Joined Tables
· Dynamic Parameter Specification
Open SQL for Java supports the following subset of statements
· Queries
· Data manipulation language
For more information about the Open SQL syntax, see Open SQL Grammar.