News, views, and items of interest on IBM's Db2 database management system and mainframes.
Showing posts with label
Dynamic SQL
.
Show all posts
Showing posts with label
Dynamic SQL
.
Show all posts
Monday, November 15, 2021
Db2, SQL, and Modern Coding Techniques
›
Mainframe application development has changed dramatically during the lifetime of Db2. Way back in the beginning, and even for a long time...
2 comments:
Friday, February 24, 2017
The DB2 12 for z/OS Blog Series - Part 5: Enhancements for Managing Dynamic and Static SQL
›
Most modern application development is done using dynamic SQL. But some features work only with static SQL and others only with dynamic SQL...
Tuesday, February 25, 2014
Dynamic SQL - Let's Do The Math
›
We've come a long way in the world of DB2 in the past decade or so. I remember way back when it was common for DBAs to say "If p...
Friday, September 04, 2009
Dynamic SQL Causing Lock Escalation?
›
Lock escalation is the promotion of a lock from a row, page or LOB lock to a table space lock because the number of page locks that are conc...
3 comments:
Friday, January 25, 2008
Get Control of Access Path Changes for Dynamic SQL when Migrating to a New Version of DB2
›
Are you making plans to migrate to a new version of DB2? Do you know what impact the access changes for dynamic SQL will have on performance...
›
Home
View web version