Peter, While you might find this external table does not exist (physically), the data dictionary of your database believes it does exist. Did you check your data dictionary?
rr -----Original Message----- From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED] Sent: Friday, June 30, 2006 2:31 PM 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. nv01()=> \d b_sdl_123456_p_dlvrb_study_att Did not find any relation named "b_sdl_123456_p_dlvrb_study_att". The $sqlString is: CREATE EXTERNAL TABLE b_sdl_123456_p_dlvrb_study_att SAMEAS a_sdl_123456_p_dlvrb_study_att USING ( DATAOBJECT ('/to_the_directory_path/b_sdl_123456_p_dlvrb_study_att.dat') DELIMITER '|' DATEDELIM '-' ESCAPECHAR '\' TIMEDELIM ':' DATESTYLE 'YMD' TRUNCSTRING ON CTRLCHARS ON FILLRECORD ON MAXERRORS 10000 ) 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 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 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 returned value. Can someone advise as to the best way to execute commands that does not require return values? Thanks. Peter This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system. This E-mail message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply E-mail, and destroy all copies of the original message.
