Problem solve Get help with specific problems with your technologies, process and projects.

Is there a bug in DB2 Connect?

I am using DB2 Connect with Microsoft Access to query data on an iSeries. When I run simple one-table queries on a large table (1.25 million records) with a simple select "where MYCHARFIELD = 'T') I not only get records where MYCHARFIELD = T but also a few records where it has C or E or P. Is there a bug in DB2 Connect that would cause this to happen. This happens even if I use the graphical query building tool. I can not use the Client Access ODBC driver to do this because it times out and will not run it.
I am not aware of a known bug that will cause the described situation. Please check the results by using iSeries access as follows:

  • Operation Navigator
  • Database
  • SQL script center
  • Run the SQL request

    This uses JDBC connection and sees what the results are.

    Note: I find the ODBC driver of iSeries Access superior to DB2 Connect most of the time, please recheck why it times out.


    Visit the ITKnowledge Exchange and get answers to your connectivity questions fast.

    The Best Web Links: Tips, tutorials and more.

    PC/Windows connectivity expert Shahar Mor is available to answer your toughest networking questions. Ask Shahar a question or read his previously answered questions here.

  • Dig Deeper on FTP

    Have a question for an expert?

    Please add a title for your question

    Get answers from a TechTarget expert on whatever's puzzling you.

    You will be able to add details on the next page.

    Start the conversation

    Send me notifications when other members comment.

    Please create a username to comment.