To: Reidy, Ron; DBI-Users
Subject: RE: sth-do()
Hi Ron,
Here is the error message, however, this external table does not exist.
DBD::ODBC::db do failed: [unixODBC]ERROR: Relation
'b_sdl_123456_p_dlvrb_study_att' already exists (SQL-HY000)(DBD: Execute
immediate failed err=-1) at ./try.pl line 54
;
}
if ($@) {
.
.
.
}
Thanks for all your input.
Peter
-Original Message-
From: Reidy, Ron [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 05, 2006 3:18 AM
To: Loo, Peter # PHX; DBI-Users
Subject: RE: sth-do()
Peter,
While you might find this external table does not exist
And the error is?
-Original Message-
From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED]
Sent: Friday, June 30, 2006 1:51 PM
To: DBI-Users
Subject: sth-do()
Hi All,
I need to issue commands such as (CREATE TABLE, DROP TABLE, ALTER
TABLE, etc...), however, whenever I use
Loo, Peter # PHX wrote:
Hi All,
I need to issue commands such as (CREATE TABLE, DROP TABLE,
ALTER TABLE, etc...), however, whenever I use sth-do($sqlString),
I get an error. I understand that using sth-do(), it goes through
the process of prepare and execute. With that, it is expecting a
Sorry about. I meant $dbh-do(). I am trying to get the error message
for Ron now.
Peter Loo
Wolters Kluwer Health
(602) 381-9553
-Original Message-
From: Garrett, Philip (MAN-Corporate)
[mailto:[EMAIL PROTECTED]
Sent: Friday, June 30, 2006 12:57 PM
To: DBI-Users
Subject: RE: sth-do
'\' TIMEDELIM ':' DATESTYLE 'YMD'
TRUNCSTRING ON CTRLCHARS ON FILLRECORD ON MAXERRORS 1 )
Thanks.
Peter
-Original Message-
From: Reidy, Ron [mailto:[EMAIL PROTECTED]
Sent: Friday, June 30, 2006 12:55 PM
To: Loo, Peter # PHX; DBI-Users
Subject: RE: sth-do()
And the error