Steve Riddle · Sep 2, 2022

How to make all existing ClassMethods and Queries "SqlProc" within tables


We have a large number of tables with an even larger number of Queries and Class Methods within them and we wish to add the SqlProc keyword to all of them.

Does anyone know if there is a simple way to do this other than by pasting [ SqlProc ] to each method/query? i.e. placing a keyword at the class level rather than a method/query level.

Product version: IRIS 2022.1
0 131
Discussion (3)3
Log in or sign up to continue

I don't think you can add SqlProc at class level, but you can modify the class definition programmatically.

Look at the class %Dictionary.MethodDefinition and the property SqlProc, if you set it to 1 is the same as adding [SqlProc] to the method.

%Dictionary.MethodDefinition is a child class of %Dictionary.ClassDefinition.

Of course I advise you to test it in a temporary system/namespace before...

Hope it helps,


Or you can just change the files in VSCode using Find and Replace with some wise regular expression