All Forums Database
hyma 33 posts Joined 07/11
01 Apr 2014
Upgrade TD14.10 and Reserved Words

I'm currently working on the Database upgrade on TD14.10. Concerning the reserved words I get a long list of conflict names (reserved names) that should be renamed or double-quoted.
Certainly it will take a lot of time to rename and to test.
Any body has experience on it? What if I'd just ignore and start installing TD14.10?

Raja_KT 1246 posts Joined 07/09
01 Apr 2014

You mean SYSLIB.SQLRestrictedWords  where you have  keywords???
If it is me, even though if I am almost 100% sure, I take a backup somewhere. It may become handy somewhere down the line when it calls for explanation of code breaks..... 
I can go for a quick comparison too(sort and then compare in excel or unix)
Finally, you see what is important.

Raja K Thaw
My wiki:
Street Children suffer not by their fault. We can help them if we want.

hyma 33 posts Joined 07/11
01 Apr 2014

Thank you Raja.
Because renaming all conflict words will be quite time-consuming (incl. testing), I'd like to know what will happen after the upgrade if I just ignore the reserved words and don't change anything at all. Put another way, are there any critical consequences if the conflict words have not been renamed? 

carrie 21 posts Joined 04/08
02 Apr 2014

There should not be too many new reserved words.  In general, developers try to avoid adding new reserved words, especially ones that might cause a conflict.  
Are you perhaps referring to new non-reserved keywords?   While it is recommended that they not be used as names to avoid confusion, there is no requirement to do so.
Thanks, -Carrie

hyma 33 posts Joined 07/11
04 Apr 2014

I really meant the reserved words. To be more precise, there are not many reserved words (for TPT). However, the few words are being used in many tables. At now, I don't think to rename all these names in all affected tables but rather check all TPT scripts to find out only those that contain conflict words and change only these names. So the to-do list could be shortened significally.

Adeel Chaudhry 773 posts Joined 04/08
08 Apr 2014

How many tables/scripts are there we are talking about?
Also is there any ETL/BI tool being used which might have an impact?
Is the solution in production?
Which current version of TD are you using?

-- If you are stuck at something .... consider it an opportunity to think anew.

syedrehanahmad 1 post Joined 04/11
11 Aug 2014

Hello All,
If anyone of you have resolved the issue of reserved words in TD14.10, please help me with the approach/methodology. I would be helpful to you.


You must sign in to leave a comment.