The Db2 Portal Blog

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

About Me

My photo
Craig S. Mullins
Sugar Land, Texas, United States
Craig S. Mullins is a data management strategist, researcher, and consultant. He is president and principal consultant of Mullins Consulting, Inc. and the publisher/editor for The Database Site.

Craig has been named by IBM as a Gold Consultant and an IBM Champion for Analytics. He has been named as one of the Top 200 Thought Leaders in Big Data and Analytics by AnalyticsWeek magazine.

Craig has over three decades of experience in all facets of database systems development and has worked with Db2 since V1. You may know Craig from his popular books: Db2 Developer's Guide (covering IBM's mainframe RDBMS)... A Guide to Db2 Performance for Application Developers (how to write efficient Db2 programs) and... Database Administration: The Complete Guide to DBA Practices and Procedures (a guide to heterogenous DBA).
View my complete profile
Powered by Blogger.