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