SQL/MX Programming Manual for Java

SQLJ Programming
HP NonStop SQL/MX Programming Manual for Java—523726-003
3-3
Comments
example, SELECT, FROM, WHERE, table and view names, and so on) are case-
insensitive.
For the syntax of an executable clause, see Executable Clause on page A-4. For a list
of SQL statements that are allowed in SQLJ executable clauses, see Supported SQL
Statements on page A-8.
Example
This DELETE statement is coded as an SQLJ executable clause:
#sql {DELETE FROM employee};
Comments
You can include SQL and Java comments in an SQLJ program. Comments are useful
for describing a statement, host expression, method, or other part of the program. For
debugging purposes, use comments to disable specific parts of the program without
removing those parts from the source code.
Java Comments
Use Java comments anywhere in the Java parts of an SQLJ program. In an embedded
SQL statement, Java comments are accepted only within host expressions.
To specify a Java comment, enclose the comment in /* ... */ or begin the
comment with // and end the comment at the end of the line:
/* Java-comment-text */
// Java-comment-text-to-the-end-of-the-line
SQL Comments
Use SQL comments within embedded SQL statements but not within a literal or a host
expression. In a host expression, use only Java comments.
SQL comments begin with a double hyphen (--) and end at the end of the line:
-- SQL-comment-text-to-the-end-of-the-line
Example
This example shows both Java and SQL comments:
// Execute a SELECT statement (Java comment)
#sql { SELECT last_name
INTO :empname -- SQL comment
FROM employee
WHERE salary LIKE :(argv[2]+500 /* Java comment */)
AND deptnum = 3100 -- SQL comment };
...