by Craig S. Mullins | Dec 6, 2021 | views
Historically, one of the most fertile grounds for disagreement between database professionals was the appropriate usage of views. Some analysts promote the liberal creation and usage of views, whereas others preach a more conservative approach.When properly...
by Craig S. Mullins | Nov 22, 2021 | big data, LOB, unstructured data
Let's take a look at the burgeoning role of "unstructured" data and the impact of using LOBs to store that data in our Db2 databases. The Growth of "Unstructured" Data Although structured data remains the bedrock of the information infrastructure in most...
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...
Recent Comments