· 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
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,