We continue our series on DB2 for z/OS Application Development in this post by Emil Kotrc.
I am a big fan of minimizing the calls to DB2 and run as few SQL as possible. That is one of the reason I like the MERGE statement although it is a bit limited in DB2 for z/OS. In this short blog I would like to mention another of my favorite SQL tricks - SELECT FROM data-change-table-reference.
On oldie but a goodie by Dan Luksetich. All still relevant today.
Ever hear the saying that the most efficient SQL statement is the one that is never executed? Well, it’s true.