RESERVED WORDS: Query to identify reserved words in procedure

Database

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.

3 REPLIES

Re: RESERVED WORDS: Query to identify reserved words in procedure

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

Re: RESERVED WORDS: Query to identify reserved words in procedure

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.

Re: RESERVED WORDS: Query to identify reserved words in procedure

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