We have been working over the past several months with a client who has DataStage (IBM Information Manager). At one point we reached a fork in the road and had a choice of which interface to use into the database - ODBC vs API.
Not sure exactly why we chose ODBC stage to connect to Teradata vs the API but we did. We felt good about doing so.
So why am I wondering if this was still a good route. It seemed to make so much sense, but we are having so much trouble keeping the DataStage .ini configuration stable to not have random Abend issues. ODBC should be a perfect fit except when we use fast export or another more specific utility from Teradata.
OK so it should be fine. The Oracle interfaces don't seem to have this issue.
It was and probably is fine.
But if it can not remain stable it is not fine.
Outside of theoretical rhetoric, has anyone else had that issue?