(Mark Gillis) The previous blog (http://db2geek.triton.co.uk/pivoting-unpivoting-data-purexml ) was looking at how to ‘unpivot’ data: take a string of values stored in a single VARCHAR column and present them as a set of single values.
Tag: IBM
Creating Hybrid Clouds with IBM Bluemix Integration Services
(David Kwock, Rahul Gupta and Vasfi Gucer) Hybrid Cloud is the integration of multiple clouds that are aligned to the unique characteristics of the different system types. IBM defines hybrid cloud as the secure use of services from two or more sources, including the private cloud, public cloud, or t
DB2 User-Defined Functions – Extending Database Capabilities
(Daniel Luksetich) DB2 comes with a wide variety of built-in functions that enable some incredible functionality within the context of SQL statements. These functions allow for developers to very quickly incorporate application functionality inside SQL statements for fast deployment of features and
The Client Application Correlation Token
(Troy L Coleman) The client application correlation token is another helpful tool delivered with DB2 11. But before getting into the details, let’s briefly recount at the history of the correlation-id, or CORR-ID.
Managing Big Data DBAs — DB Support with Big Data
(Lockwood Lyon) Big data applications typically involve:
How to improve performance of your older COBOL programs
(Willie Favero) COBOL has been around for more than 50 years now. According to 1997 report by the Gartner Group, it was estimated that at that point in time, there were a total of 200 billion lines of COBOL in existence running about 80% of all business programs.
IDUG EMEA 2015 Day 3
(Julian) So, Day 3 of this year’s IDUG Europe is in the books, and as usual it’s been a busy one. After all of the frantic activity leading up to Monday’s Triton/DBI party, last night the DB2 Geeks stepped it down a notch and visited the excellent F.X. Buckley restaurant for our traditional Tuesday
Hybrid Cloud Data and API Integration: Integrate Your Enterprise and Cloud with Bluemix Integration Services
(Srinivas Cheemalapati, Yi-an Chang, Shahir Daya, Matthieu Debeaux, Odilon Magroski Goulart, Vasfi Gucer, Rahul Gupta, Shamim Hossain, David Kwock, Jordan T Moore, David N Nguyen and Bobby Woolf) IBM Hybrid Integration Services is a set of hybrid cloud capabilities in IBM Bluemix that allows busines
Hadoop SQL: 4 Reasons Why BigInsights Is the Best
(Dave Beulke) The latest release of the IBM BigInsights for Apache Hadoop is really taking off because of its great Hadoop SQL functionality, its SQL performance, and standard security model.
IDUG EMEA 2015 Day 2
(Mark Gillis) I always enjoy a chat with the locals when we have an IDUG event so I spent the 30 minute taxi journey from the airport to the hotel in conversation with my driver. I think I actually understood about 3 words.