Hello Experts,
I had this doubt as to which connector to use to connect to i-series? Should i prefer DB2 or ODBC? Currently i am able to connect with both but is there any pros and cons of these two, i mean which one should i chose ? Are there any factors to be considered?
I-series- DB2 connector or ODBC connector
Moderators: chulett, rschirm, roy
-
skathaitrooney
- Participant
- Posts: 103
- Joined: Tue Jan 06, 2015 4:30 am
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
As a general rule, a native Connector should be preferred over ODBC.
For DB2 there's not a huge amount of difference, as the DB2 API is modelled on ODBC standards. But there is one major difference; the DB2 Connector stage inherently handles DB2 partitioning.
For DB2 there's not a huge amount of difference, as the DB2 API is modelled on ODBC standards. But there is one major difference; the DB2 Connector stage inherently handles DB2 partitioning.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.