Db2, SQL, and Modern Coding Techniques

by | Nov 15, 2021 | BIND, Dynamic SQL, sql

 Mainframe application development has changed dramatically during the lifetime of Db2. Way back in the beginning, and even for a long time thereafter, most Db2 programs were written in COBOL and coded to use static SQL. This meant that the SQL was bound before...

SQL to Return the nth Maximum Value

by | Aug 16, 2021 | CTE, sql

Sometimes what seems like a simple request might take a little bit of thinking to devise and implement a solution. Recently, I was asked how to write SQL that returns the nth maximum value from a column. If you think about it, it isn't too difficult.Assume that you...

Deleting “n” Rows From a Db2 Table

by | Nov 18, 2020 | DELETE, sql

I regularly receive database- and Db2-related questions via e-mail. And that is great, but I don't always get a chance to respond to everything. If you've sent me a question and I haven't replied, I apologize. But every now and then, I will use one of the e-mail...

Blaze-Persistence: Use Modern SQL like native JPA

by | Oct 16, 2020 | sql

Markus recently published a video in which he talks about Java & SQL, and that lead to a little discussion with me on Twitter. The conclusion Markus often came to is that one has to revert to writing plain SQL for some of the more advanced use cases because of...