Specifying Comments

To use comments after SQL statements, introduce the comment text with one of the following comment indicators:

• The double-hyphen (--) complies with the ANSI SQL standard.
• Braces ( { } ) are an Informix extension to the ANSI 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 ('A1A2B1B2abcd', '123')   -- A1A2 and B1B2 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 on SQL comments and comment indicators, see the IBM Informix: Guide to SQL Syntax.