Specify a DOCUMENT clause

The DOCUMENT and WITH LISTING IN clauses follow END PROCEDURE or END FUNCTION statements.

The DOCUMENT clause lets you add comments to your SPL routine that another routine can select from the system catalog tables, if needed. The DOCUMENT clause in the following figure contains a usage statement that shows a user how to run the SPL routine.

Figure 1. Usage statement that shows a user how to run the SPL routine.

CREATE FUNCTION raise_prices(per_cent INT)
. . .
END FUNCTION
   DOCUMENT "USAGE: EXECUTE FUNCTION raise_prices (xxx)",
            "xxx = percentage from 1 - 100";

Remember to place single or double quotation marks around the literal clause. If the literal clause extends past one line, place quotation marks around each line.