This is one of those data type conversions which I occasionally have to do in DataStage, but can never seem to remember. So, I thought I would write this quick post to document the data type conversion code, which is really easy, once I finally remember how to do it again. The TimestampFromDateTime Function DataStage … Continue reading DataStage – Timestamp from date
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
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
During the course of the week, the discussion happened regarding the different places where a person might read the DataStage and QualityStage logs in InfoSphere. I hadn't really thought about it, but here are a few places that come to mind: IBM InfoSphere DataStage and QualityStage Operations Console IBM InfoSphere DataStage and QualityStage Director client IBM InfoSphere … Continue reading Infosphere Information Server (IIS) – Where you can view DataStage and QualityStage Logs?
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
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?