Synonyms go UN-deprecated in DB2 11

Posted Saturday, April 16, 2016

My Blogs

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”.

This entry was posted in DB2 11, DB2 for z/OS, SQL and tagged , , , , , , . Bookmark the permalink.

Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s