Linux For those people who dip their toe into Linux systems for the first time, the endless options for distributions can be overwhelming, mainly when you are unsure for what to search. Just a few years ago when Linux was still in its early stages, this task would be much more comfortable as you could … Continue reading 5 Best Linux Distros for Beginners
Linux Do you think that the command lines are an old-fashion leftover from previous decades or an antiquated way of using a PC? Think again. Indeed, it is one of the most powerful and flexible ways to perform and manage in Linux. If you come from the comfort of a Mac or Window desktop, however, … Continue reading 8 Most Useful Linux Commands For Beginners
End of Support for IBM InfoSphere Information Server 9.1.0 IBM InfoSphere Information Server 9.1.0 will reach End of Support on 2018-09-30. If you are still on the InfoSphere Information Server (IIS) 9.1.0, I hope you have a plan to migrate to an 11-series version soon. InfoSphere Information Server (IIS) 11.7 would be worth considering if you … Continue reading End Of Support For IBM InfoSphere 9.1.0
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
While investigating a recent Infosphere Information Server (IIS), Datastage, Essbase Connect error I found the explanations of the probable causes of the error not to be terribly meaningful. So, now that I have run our error to ground, I thought it might be nice to jot down a quick note of the potential cause of … Continue reading Essbase Connector Error – Client Commands are Currently Not Being Accepted
Transact SQL (T-SQL) When it comes to SQL I tend to lean on the SQL I have used the most over the years, which is Oracle. Today was no exception, I found myself trying to use the TO_CHAR command in SQL Server to format a date, which of course does not work. So, after a … Continue reading Oracle TO_CHAR to SQL Server CONVERT Equivalents to change Date to String
While chasing an error to which only applied to join type stages, I thought it might be nice to identify what the InfoSphere Information Server DataStage / QualityStage are. There are three of them, as you can see from the picture above, which are the: Join Stage, Lookup Stage, And, Merge Stage. All three stages that … Continue reading What Are The DataStage / QualityStage Join Stages?