SQL/MX Programming Manual for Java

SQLJ Syntax

HP NonStop SQL/MX Programming Manual for Java—523726-003

A-5

Statement Clause

A statement clause contains an embedded SQL statement.

SQL-statement

specifies one of the supported SQL/MX statements listed in Supported SQL

Statements on page A-8. The SQL statement must be enclosed in curly braces

({}) and must not be terminated by a semicolon (;).

For the syntax of the SQL statements, see the SQL/MX Reference Manual.

Assignment Clause

An assignment clause assigns the value of an SQL operation to a left-hand Java

expression.

Java-ID

is the identifier of a Java variable, which is case-sensitive. The variable should be

declared as an iterator type. See Iterators and Result Sets on page 3-48.

Query Clause

A query clause specifies an SQL query expression.

query-expression

generates a source table consisting of rows of values to be assigned to a left-hand

Java expression. You cannot assign a SELECT INTO statement to an iterator

variable. For the syntax of the query expression, see the SELECT statement in the

SQL/MX Reference Manual. For more information, see Assigning Query Results to

a Positioned Iterator Object on page 3-49 and Assigning Query Results to a

Named Iterator Object on page 3-52.

statement-clause is:

"{"

SQL-statement "}"

assignment-clause is:

Java-ID = "{" assignment-specific-clause "}"

assignment-specific-clause is:

query-clause

iterator-conversion-clause

query-clause is:

query-expression [FOR UPDATE]