Skip to main content


Retain embedded SQL statements as comments in source code.


[SQL]    Comment=n

n is either 1 or 0. The default value is 1.


When Comment is enabled (n = 1), embedded SQL statements are retained as comments in the source code (.INT) version of the routine.

Changing This Parameter

To set the desired value for Comment from the Terminal, use the SetOption(“RetainSQL”) method of the %SYSTEM.SQL.Util class. See the class reference for details.

You can also change Comment with the Config.SQL class (as described in the class reference) or by editing the CPF in a text editor (as described in the Editing the Active CPF section of the “Introduction to the Configuration Parameter File” chapter in this book).