(Ted Holt) We all know that the SQL SELECT statement only retrieves data, right? If you want to modify data, you have to use INSERT, UPDATE, DELETE, or MERGE, correct? Well, to quote the great George Gershwin, It Ain’t Necessarily So. You can modify data from a SELECT statement, and maybe sometimes
(Joe Pluta) In my previous article, I explained how to use extension files to encapsulate a legacy database. This allows you to add new data points to the database without the impact of changing an existing master file.
(Kevin Oliver) Let’s be honest: no one wakes up in the morning excited to go through a procurement process. This reaction can be particularly true where data management is concerned. When quick responses to market changes are necessary, it’s essential to be able to adjust your architecture rapidly w
(Mark Simmonds) Throughout history, some sectors of society have rejected automation and technology—partly because of the fear of “letting go” control to the machines. Yet if we don’t relinquish some control, we humans become a bottleneck.
(Gareth Copplestone-Jones) This DB2 for z/OS Locking blog series is mostly targeted at DB2 for z/OS application developers, but is also appropriate for application designers, database administrators, DB2 systems programmers and other DB2 professionals who are concerned with data integrity and applic
(Robert Catterall) In the Part 1 post of this two-part blog entry, I described how RACF can be used to provide “external” security for a Db2 for z/OS system – external security being concerned with who (i.e., which IDs) can connect to the Db2 system, and how (e.g., in the form of a batch program and
(Julianna Delua) Welcome to 2020. As we take a look back to reflect on the state of digital transformation in today’s businesses, we can see several key trends emerging.
(Paul Tuohy) I recently had a discussion with some of my colleagues about the increased use of Data Definition Language (DDL) in SQL to define a database as opposed to traditional DDS.
(Paul Tuohy) In this article, I want to share with you an SQL scalar function that I happen to have been using quite a bit recently. At times, when using an SQL select statement, you may want to format a number or date.
(Martin) 100% of our studio audience learned something!Michael gave a deep dive into the latest log improvements in Db2 11.5.