Specify comments

To use comments after SQL statements, you must use a comment indicator.

Introduce the comment text with one of the following comment indicators:

The double-hyphen (--) complies with the ANSI SQL standard.
Braces ( { ... } ) are the HCL® OneDB® extension to the ANSI standard.
C-style slash-and-asterisk ( /* . . . */ ) complies with the SQL-99 standard.

In a nondefault locale, you can use any characters in the code set of your locale within a comment. If the locale supports a code set with non-ASCII characters, you can use these characters in an SQL comment.

In the following example, the user inserts a column value that includes multibyte characters in the table mytable:

EXEC SQL insert into mytable
   values ('A¹A²B¹B²abcd', '123')   -- A¹A²andB¹B²are multibyte characters.

In this example, the SQL comment includes the multibyte characters A¹A² and B¹B². This example assumes that the locale supports a multibyte code set that includes the A¹A² and B¹B² characters. For more information about SQL comments and comment indicators, see the HCL OneDB Guide to SQL: Syntax.