Unanswered: ODBC Driver DB2...ISeries access vs Client access express vs datadirect
We have moved systems from an onsite as400 to a hosted iseries. I don't have any access to the hosted server as far as admin level rights so I don't know what the os version is.
Anyways, is Client access express v5r2 really that much better than Iseries connect? The datadirect driver is pretty good, but I need the host name and license key to get it to work, and it kind of eats itself on some joins...and is missing some odbc functions (though they say they work...not so much).
I was using ssis to read info out of our as400 running 4 or 5 queries at the same time, and now since I switched the odbc driver to iseries I have nothing but errors, unless I run them one at a time it seems.
Should I use the CLAE odbc driver (ibm even recommends odbc over their ole driver ....lots of decimal buffer overflows and datetime issues, unless you cast all the decimals in your sql. The iseries data viewer can't even display it's own results half the time (timestamp/pack fields with null or '1-1-0001' value).
Can I even use the CLAE drivers with a zseries, or whatever an iseries is?