| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| CLS vs ODBC vs JDBC |
« View previous topic :: View next topic » |
| Author |
Message
|
| Gideon |
 Posted: Fri Jul 08, 2011 11:45 am Post subject: CLS vs ODBC vs JDBC |
 |
|
Chevalier
Joined: 18 Aug 2009
Posts: 403
|
When connecting to a Database, is it possible to connect via CLI instead of ODBC for better performance ?
I have not seen that as an option, just wondering |
|
| Back to top |
|
 |
| lancelotlinc |
| Posted: Fri Jul 08, 2011 11:52 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
ODBC uses CLI for DB2.
https://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.apdv.cli.doc/doc/c0007944.htm
| Quote: |
DB2 Call Level Interface (DB2® CLI) is IBM's callable SQL interface to the DB2 family of database servers. It is a 'C' and 'C++' application programming interface for relational database access that uses function calls to pass dynamic SQL statements as function arguments. It is an alternative to embedded dynamic SQL, but unlike embedded SQL, DB2 CLI does not require host variables or a precompiler.
DB2 CLI is based on the Microsoft®** Open Database Connectivity** (ODBC) specification, and the International Standard for SQL/CLI. These specifications were chosen as the basis for the DB2 Call Level Interface in an effort to follow industry standards and to provide a shorter learning curve for those application programmers already familiar with either of these database interfaces. In addition, some DB2 specific extensions have been added to help the application programmer specifically exploit DB2 features.
The DB2 CLI driver also acts as an ODBC driver when loaded by an ODBC driver manager. It conforms to ODBC 3.51.
|
How's that training coming?
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| Gideon |
| Posted: Fri Jul 08, 2011 3:37 pm Post subject: |
|
|
Chevalier
Joined: 18 Aug 2009
Posts: 403
|
Yes, its there in black and white. However, our DBA tells me that CLI is native and ODBC is not, and CLI will run faster. But I see your point. It is confusing to see different points of view about a technology, and when you register a data source it registers as ODBC/CLI
To answer your question, I am in the process of trying to get approval |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Mon Jul 11, 2011 4:35 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
Good luck on your training approval.
The performance difference is negligible. Writing functionality in WebSphere Message Broker is not like writing functionality in C language. Tell your DBA that WMB ODBC operations are faster than C language CLI operations because of the way WMB processes data. See what he says about that. If you like, post his response and we'll start a mega discussion.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
