in reply to How to load a DB2 database using PERL

LOAD is not an SQL statement, it is a command. Therefore it can't be executed via DBI (or JDBC, ODBC, etc). You need to execute it using either the system() call in perl or by opening the command and reading from the pipe, e.g., open(LOAD, "db2 load from ... |"); Or write a perl XS module that calls the sqluload() API! ;-) Good luck,
  • Comment on Re: How to load a DB2 database using PERL