Re: problem with Class-dbi set_up_table function(no primary key error)

2005-10-31 Thread Sam Tregar
On Mon, 31 Oct 2005 [EMAIL PROTECTED] wrote: Hi, sorry to bother you again. I am still trying to load data in my db2 database using class-dbi in a perl script. I am blocked on the dbi set_up_table function called in my script: Chado::Tableinfo->set_up_table('tableinfo'); There are the wrong ma

problem with Class-dbi set_up_table function(no primary key error)

2005-10-31 Thread noumene
Hi, sorry to bother you again. I am still trying to load data in my db2 database using class-dbi in a perl script. I am blocked on the dbi set_up_table function called in my script: Chado::Tableinfo->set_up_table('tableinfo'); This is the error i got: Chado::Tableinfo has no primary key at /usr/l

Re: Problem loading data in a DB2 database via perl-DBI

2005-10-31 Thread Dan Scott
Can you please post the Perl code you're using (or at least the section relevant to the prepare_cached() method and failure) so we can give you a little more help? Thanks, Dan On 10/31/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hi, I am using a perl script to load data in a DB2 database

Problem loading data in a DB2 database via perl-DBI

2005-10-31 Thread noumene
Hi, I am using a perl script to load data in a DB2 database and i obtain these errors: DBD::DB2::db prepare_cached failed: [IBM][CLI Driver][DB2/LINUX] SQL0104N An unexpected token "END-OF-STATEMENT" was found following "ublic.db_db_id_seq')". Expected tokens may include: "". SQLSTATE=42601 I