DB2 connection question

I have a project that I need to connect to a DB2 database on an AS400
from a perl application on a Linux box. I've been reading as much as I
can but have a few questions for those with experience in a similar
task.

My options appear to be to use ODBC or DBD::DB2. What are the
advantages/disadvantages of using either one?

If I use DBD::DB2, according to the README file I will need the DB2
Application Development Client. Is this something I need to purchase a
specific license for Linux or if I have an AS400 license can I get a
Linux version and use it? Can I get the client only or do I need to get
the whole DB2 Universal Developer's Edition? Sorry if I'm not asking
the correct questions.

If I use ODBC, which ODBC driver is recommended (i'm running Red Hat 9)?
Is there a good free one that I can use for development?

Any help is greatly appreciated. Thanks in advance

Keith Jackson

Relevant Pages

  • Re: DB2 drivers? (ODBC)
    ... DB2 for Linux is: ... an application development client (this will give you the libdb2.so ... an ODBC driver manager -- unixODBC is supported with DB2. ... >>site to get a linux DB2 driver. ...
    (comp.lang.php)
  • Re: Build tclodbc on linux
    ... > I have a hacked up version of tclodbc that runs on Linux using the db2 ... > CLI interface which is based on odbc. ...
    (comp.lang.tcl)
  • Re: Simple query executes fast but renders slow...
    ... So, ODBC, right? ... no database engine can perform ... I've spent a lot of time on a PC running Access Queries against a DB2 ...
    (microsoft.public.access.queries)
  • Re: MS SQL Server driver
    ... BA>> Brad Anderson writes: ... BA>>> change based on this requirement) on Linux, ... BA>>> SQL Server cluster via sockets. ... IMHO they cannot invent anything better and more native for MSSS than ODBC. ...
    (comp.lang.lisp)
  • RE: Data Transfer b/w SQL Server 2005 and DB2 UDB.
    ... Your IBM guy may like the ODBC method because it's easy for him, ... install the Microsoft OLE DB for DB2 Provider (you will need ... colleagues, a DB2 DBA, has helped me in setting up the ODBC DSN for DB2 and I ...
    (microsoft.public.sqlserver.dts)