In most host languages, static SQL statements can include host language or SQL comments. In Java™ and REXX, static SQL statements cannot include host language or SQL comments.
Dynamic SQL statements can include SQL comments.
There are two types of SQL comments:
These rules apply to the use of simple comments:
These rules apply to the use of bracketed comments:
A comment embedded in an SQL statement that
precedes a name (such as a table name) may cause object names in the
text saved for a view, trigger, variable, or MQT to not be maintained
correctly. Similarly, names in rows of a dependency view
(such as SYSTRIGDEP) may not be correctly qualified.
This example shows how to include simple comments in a statement:
CREATE VIEW PRJ_MAXPER -- PROJECTS WITH MOST SUPPORT PERSONNEL AS SELECT PROJNO, PROJNAME -- NUMBER AND NAME OF PROJECT FROM PROJECT WHERE DEPTNO = 'E21' -- SYSTEMS SUPPORT DEPT CODE AND PRSTAFF > 1
This example shows how to include bracketed comments in a statement:
CREATE VIEW PRJ_MAXPER /* PROJECTS WITH MOST SUPPORT PERSONNEL */ AS SELECT PROJNO, PROJNAME /* NUMBER AND NAME OF PROJECT */ FROM PROJECT WHERE DEPTNO = 'E21' /* SYSTEMS SUPPORT DEPT CODE */ AND PRSTAFF > 1