Home > Ask the AS/400 Experts > DB2/400 and DB2 UDB Questions & Answers > Alternatives to ODBC
Ask The iSeries 400 Expert: Questions & Answers
EMAIL THIS

Alternatives to ODBC

Shahar Mor EXPERT RESPONSE FROM: Shahar Mor

Pose a Question
Other iSeries 400 Categories
Meet all iSeries 400 Experts
Become an Expert for this site


iSeries news and advice
Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google


>
QUESTION POSED ON: 15 April 2008
Our Database people are discontinuing ODBC access because of performance reasons. What are the alternatives to ODBC?

>
EXPERT RESPONSE
In my experience odbc is not "slow by default." When investigating performance issues in distributed environment working with db2/400, I almost always found that the slow part was SQL proccessing on the database (i.e. because of a missing index) and not the ODC layer. So I would advise you not to discontinue ODBC use that easily.

That being said, an alternative can be the ado.net provider that works very well (and is supposed to be slightly faster then ODBC). It is offered by iSeries Access and more details can be found here.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google


RELATED CONTENT
DB2/400 and DB2 UDB
Auditing: RPG with embedded SQL showing up as a changed object
Selecting a PF with multiple members from SQL
Referencing a renamed column on SELECT clause in SQL
Using WebSphere information integrator to access MS server data using SQLRPGLE
Joining files using SQLRPGLE
Querying system catalog tables to determine table alias
Excluding characters from AS/400 DB2 SELECT statements prevents mapping errors
How to use the QQQVEXPL API
Using SQL syntax to override DB2 automatic column name generator on iSeries
Making a file with an automatic key in iSeries with DDS keyword

DB2 UDB (universal databases)
Auditing: RPG with embedded SQL showing up as a changed object
DB2 on AS/400: What has it done for me lately?
How to: Transfer unlimited data to Excel from AS/400
What is an integrated database?
An automated CL method of moving a query from AS/400 to Excel
Using WebSphere information integrator to access MS server data using SQLRPGLE
Querying system catalog tables to determine table alias
How to use the QQQVEXPL API
Making a file with an automatic key in iSeries with DDS keyword
Retrieving data from AS/400 into Crystal Reports
DB2 UDB (universal databases) Research

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice

HomeNewsTopicsITKnowledge ExchangeTipsBlogsAsk the ExpertsMultimediaWhite PapersProducts
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




All Rights Reserved, Copyright 1999 - 2008, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts