RE: sth-do()

2006-07-05 Thread Reidy, Ron
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

RE: sth-do()

2006-07-05 Thread Loo, Peter # PHX
; } 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

RE: sth-do()

2006-06-30 Thread Reidy, Ron
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

RE: sth-do()

2006-06-30 Thread Garrett, Philip \(MAN-Corporate\)
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

RE: sth-do()

2006-06-30 Thread Loo, Peter # PHX
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

RE: sth-do()

2006-06-30 Thread Loo, Peter # PHX
'\' 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