SQL Comments

How to Embed SQL Comments

You can embed an SQL comment within an SQL statement. SQL comments may be used in both interactive and embedded SQL statements.

An SQL comment:

Begins with two consecutive hyphens (--)
Consists of any combination of numbers, letters, spaces, and other characters
Ends at the end of the line

Bracketed comment:

A bracketed comment starts with the bracket introducer string '/*' and ends with the bracket terminator string '*/'.
Bracketed comments can span multiple lines.
The bracket introducer and terminator strings can not split over two lines.
Can be used whenever a separator or space is allowed.
Bracketed comments are only allowed in the routine body of an SQL-routine. They are not recognized by the command facility outside this context.

Note: When defining an SQL routine using the command facility tools OCF, IDMSBCF, or using an OCF console in CA IDMS Visual DBA, the comment introducer '/*' must not be placed in column 1, because '/*' is interpreted as an end of file on input by the command facility.

Sample SQL Comments

The following example shows SQL comments with an embedded SQL statement:

select
  emp_id, emp_lname, dept_id      ── Columns to be selected
  from employee                    ── Tables containing the data
  where dept_id = 1234;            ── Selection criterion