March 10, 2010, Wednesday, 68


Comments

From SQL PL Guide for DB2

Jump to: navigation, search

Comments in DB2 stored procedures

There are two styles to comments which can be used in SQL/PL:

- The SQL-style or in-line comment, which is preceded by two dashes.
- The 2nd style is known as C-style comment. It is placed between an open comment (/*) and a close comment (*/) tag. This style can be used over mutiple lines.


Example:

create procedure myproc
 begin
    -- comment in SQL-style

    /* comment in C-style
        which can be over used
        in multiple lines */
 end!