Hi Reddy,
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.
Cheers,
Raja
Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.
Hi Raja,
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.
Thanks,
Reddy.
Hi Reddy,
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.
Good luck.
Raja
Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.
Hello Masters,
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.
Thanks,
Reddy.