I've connected to the database using DBI->connect and then I prepare the
following query:
my $sth = $dbh->prepare('select sid2,count(*) as dup_count from bio group by
sid2 having count(*) > 1') or die "Couldn't prepare statement: " .
$dbh->errstr;
I get the following messages when I run the program:
/opt/SUNWspro/bin:/usr/local/sbin:/usr/bin:/usr/ccs/bin:/usr/sbin:/usr/local
/bin:/usr/ucb:/usr/afsws/etc:/usr/afsws/bin:/home/db2inst1/sqllib/bin:/home/
db2inst1/sqllib/adm:/home/db2inst1/sqllib/misc:.:/afs/asu.edu/users/k/a/m/ka
mwb/bin:usrlocalbin
DBD::DB2::db prepare failed: [IBM][CLI Driver][DB2/6000] SQL0204N
"KAMWB.BIO" is an undefined name. SQLSTATE=42704
DBD::DB2::st execute failed: [IBM][CLI Driver][DB2/6000] SQL0727N An error
occurred during implicit system action type "2". Information returned for
the error includes SQLCODE "-204", SQLSTATE "42704" and message tokens
"KAMWB.BIO". SQLSTATE=56098
Why is my userid (kamwb) added to the table name (bio)?
