As part of 14.10 upgrade, we need to find the whether reserved words are used in any procedures. I know We can find from
DBQL logs or need to manually find the reserved word in each procedure by finding the reserved word in each ddl of the
procedure. Please share your thoughts to find the best way to identify the procedure name which used the reservered words.
For now I can think of is take show procedure for all procs into a file. Then I will match through some programs either unix(my favourite :)) or excel progamming against values from SYSLIB.SQLRestrictedWords view.
Hope it helps.
Thanks, but i used to this practice in all the previous upgrades and thought to check is there any advanced feature in 14.10 to find out.
You are welcome. Did you check in the forum , if someone has done similar task? I know it is painful if the volume is high.