How the IBM Common SQL Engine (CSE) Improves DB2

Today, newfound efficiencies and innovation are key to any business success – small, medium or large. In the rapidly evolving field of data analytics, innovative approaches to handling data are particularly important since data is the most valuable resource any business can have. IBM common SQL Engine is delivering application and query compatibility that is … Continue reading How the IBM Common SQL Engine (CSE) Improves DB2

An Overview of DB2 Federation

Data analytics has changed where data is no longer manageable in relational databases only. Data is flowing from various sources which are not of the same format. This means it is not possible to store all data in the same repository. Some are best suited for storing in relational databases, others for Apache Hadoop while … Continue reading An Overview of DB2 Federation

DataStage – Netezza Connector Action Column

Over the years have occasionally use the action column feature, however, the last month or so I have found myself using it quite a lot. This is especially true in relation to the tea set and not just in relation to the change capture stage. The first thing you need to know is, if you … Continue reading DataStage – Netezza Connector Action Column

Netezza / PureData – List of Views against a table

PureData Powered by Netezza I have found myself using this simple, but useful SQL time in recent weeks to research different issues and to help with impact analysis.  So, I thought I would post it while I’m thinking about it.  It just gives a list of views using a table, which can be handy to … Continue reading Netezza / PureData – List of Views against a table

Netezza / Puredata – How to replace or trim CHAR(0) is NULL characters in a field

Occasionally, one runs into the problem of hidden field values breaking join criteria.  I have had to clean up bad archive and conversion data with hidden characters serval times over the last couple of weeks, so, I thought I might as well capture this note for future use. I tried the Replace command which is … Continue reading Netezza / Puredata – How to replace or trim CHAR(0) is NULL characters in a field

SQL Server – how to know when a stored procedure ran last

This week I needed to know if a stored procedure was running when expected during our batch.  So, here is a quick couple of SQL to answer the question: When a Stored Procedure was run last This version of the SQL gives the date for the last time the Stored Procure was run: select distinct   … Continue reading SQL Server – how to know when a stored procedure ran last

Netezza / PureData – How to Substring on a Character

  I had a reason this week to perform a substring on a character in Netezza this week, something I have not had a need to do before.  The process was not as straightforward as I would have thought, since the command is explained as a static position command, and the IBM documentation, honestly, wasn’t … Continue reading Netezza / PureData – How to Substring on a Character