RE: sth->do()

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:Peter.Loo@xxxxxxxxxxxxxxxxxxxxxxxx]
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:Ron.Reidy@xxxxxxxxxxxxxxxxxx]
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:Peter.Loo@xxxxxxxxxxxxxxxxxxxxxxxx]
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.
.

Relevant Pages

  • RE: Réf. : RE: connect to oracle database as sysdba form windows
    ... connect to oracle database as sysdba form windows ... it and all copies from your system and notify the sender immediately by return e-mail. ... The sender does not accept liability for any errors or omissions which arise as a result. ... intended recipient, please be aware that any disclosure, copying, distribution ...
    (perl.dbi.users)
  • RE: DBI->data_sources(Oracle)
    ... As far as I understand DBD::Oracle, ... This E-mail message is for the sole use of the intended recipient ... you are not the intended recipient, please contact the sender by reply ...
    (perl.dbi.users)
  • RE: sth->do()
    ... If you are not the intended recipient, ... Please notify the sender of the delivery ... This E-mail message is for the sole use of the intended recipientand ... review, use, disclosure or distribution is prohibited. ...
    (perl.dbi.users)
  • RE: VNC HowTo or docs
    ... Matthew Polashek ... If you were not an intended recipient, ... please notify the sender and delete all copies. ...
    (Fedora)
  • RE: :ODBC::st execute failed: [unixODBC]ERROR: crossed reserve : Out of memory
    ... large result set into memory? ... If you are not the intended recipient, ... Please notify the sender of the delivery ... This E-mail message is for the sole use of the intended recipientand ...
    (perl.dbi.users)