by Craig S. Mullins | 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...
by Craig S. Mullins | Oct 19, 2021 | Boolean, data, data type, database design
Recently, I was reading an article written by Ben Brumm on using Boolean data in SQL and it got me thinking about Db2 and Boolean data. You see, if you click over to the article, you'll see that Ben talks about several popular database systems, but not Db2!So first of...
by Craig S. Mullins | Oct 11, 2021 | DB2, questions
For regular readers of this blog the title of this particular post might seem to be a bit odd. After all, why visit the Db2Portal blog if you don't know what Db2 is, right?Well, the purpose of this short post is to refer my regular readers to an article I wrote for...
by Craig S. Mullins | Aug 30, 2021 | change management, packages, REBIND
Db2 DBAs are constantly working with database objects such as Databases, Tablespaces, Tables, and Indexes. And many requirements cause DBAs to have to modify these objects. Some modifications may be simple, such as just issuing an ALTER statement. Others may be more...
by Craig S. Mullins | 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...
Recent Comments