Posted Saturday, April 16, 2016
Did you happen to read my blog post back on Jan 27, 2016 “
What are your plans for DB2’s Synonyms?” that discussed how to prepare for the eventual removal of synonyms from DB2 in some future release; how synonyms are now “deprecated” in DB2 11. Or maybe you read my April 25, 2014 post “ A question for you all about DB2 for z/OS Synonyms”?
Potentially removing synonyms from DB2 could have been a big deal for some customers. Lots of planning goes into removing all use of some feature that has been in the product since the dawn of time.
If you are in your planning stages of how to remove synonyms, I have some great news for you… you can STOP.
Synonyms have been un-deprecated (or is it undeprecated; in fact, I’m not even sure it’s a word). Regardless of the current status of the word, the important thing in today’s blog post is the current status of the synonyms. And their status is : “sticking around”.
If you were wondering how to migrate off of synonyms, you can stop wondering…
If you need a little information on how to use (code the SQL) synonyms, check out Synonyms in the IBM Knowledge Center.
You have spoken, and the DB2 lab has listened.
To quote the great philosopher “Hannibal” Smith; “I love it when a plan comes together”.
DB2 Online Handbook 