Skip to main content
Previous sectionNext section


Save the source code for cached query routines.


[SQL]    SaveMAC=n

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


When SaveMac is enabled (n = 1), the source code (.MAC and .INT) for cached query routines created through Dynamic SQL is saved.

Changing This Parameter

On the SQL page of the Management Portal (System Administration > Configuration > SQL and Object Settings > SQL), select Retain cached query source to enable SaveMac.

To set the desired value for SaveMac from the Terminal, use the SetCachedQuerySaveSource()Opens in a new window method of the %SYSTEM.SQLOpens in a new window class. See the class reference for details.

You can also change SaveMac with the Config.SQLOpens in a new window 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).

FeedbackOpens in a new window