All Forums Database
HarshaKudumula 83 posts Joined 04/09
12 Dec 2013
RESERVED WORDS: Query to identify reserved words in procedure

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.

Raja_KT 1246 posts Joined 07/09
12 Dec 2013

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.

HarshaKudumula 83 posts Joined 04/09
13 Dec 2013

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.
 
 

Raja_KT 1246 posts Joined 07/09
13 Dec 2013

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.

You must sign in to leave a comment.