SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-50
Comments
Comments
You can include comments in SQL catalogs, in SQLCI input lines, or in embedded SQL
lines.
To add or delete comments about an SQL object from an SQL catalog, use the
COMMENT statement, which is described in a separate entry.
To indicate that an SQLCI line or an embedded SQL line is a comment, precede the
comment with two hyphens (--):
-- comment
SQL considers all text between two hyphens and the end of the physical line to be a
comment. You can include a comment within a statement or command (but not within a
literal) if you use more than one physical line to enter the statement or command.
Example—Comments
Comments are useful in SQLCI input lines if you use command files that contain
SQLCI input. This example shows SQLCI output that echoes comments included in a
command file executed with the OBEY command:
>>OBEY TEST5;
>>-- This command file runs test number 5.
>> VOLUME TESTDB; -- Move to subvolume with test programs.
>>-- Set up DEFINEs for test
>> SET DEFMODE ON;
>> DELETE=*; -- Delete all current DEFINEs.
>> ADD DEFINE =A, FILE $V10.TEST5.FILEA;
>> ADD DEFINE =B, FILE $V10.TEST5.FILEB;
...