sth->do()

------_=_NextPart_001_01C69C7E.7A1CA88E
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi All,
=20
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.
=20
Can someone advise as to the best way to execute commands that does not
require return values?
=20
Thanks.
=20
Peter

------_=_NextPart_001_01C69C7E.7A1CA88E--

RE: sth->do()

And the error is?

-----Original Message-----
From: Loo, Peter # PHX [mailto:Peter.Loo@source.wolterskluwer.com]=20
Sent: Friday, June 30, 2006 1:51 PM
To: DBI-Users
Subject: sth->do()

Hi All,
=20
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.
=20
Can someone advise as to the best way to execute commands that does not
require return values?
=20
Thanks.
=20
Peter

This electronic message transmission is a PRIVATE communication which =
contains
information which may be confidential or privileged. The information is =
intended=20
to be for the use of the individual or entity named above. If you are =
not the=20
intended recipient, please be aware that any disclosure, copying, =
distribution=20
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.

RE: sth->do()

Loo, Peter # PHX wrote:
> Hi All,
>=20
> 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.

You should be using $dbh->do(), not $sth->do().

Philip

RE: sth->do()

Sorry about. I meant $dbh->do(). I am trying to get the error message
for Ron now.
=20
Peter Loo
Wolters Kluwer Health
(602) 381-9553

-----Original Message-----
From: Garrett, Philip (MAN-Corporate)
[mailto:Philip.Garrett@manheim.com]=20
Sent: Friday, June 30, 2006 12:57 PM
To: DBI-Users
Subject: RE: sth->do()

Loo, Peter # PHX wrote:
> Hi All,
>=20
> 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.

You should be using $dbh->do(), not $sth->do().

Philip


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.

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=3D-1) at ./try.pl line 54.

nv01()=3D> \d b_sdl_123456_p_dlvrb_study_att
Did not find any relation named "b_sdl_123456_p_dlvrb_study_att".=20

The $sqlString is:=20

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.
=20
Peter

-----Original Message-----
From: Reidy, Ron [mailto:Ron.Reidy@arraybiopharma.com]=20
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@source.wolterskluwer.com]
Sent: Friday, June 30, 2006 1:51 PM
To: DBI-Users
Subject: sth->do()

Hi All,
=20
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.
=20
Can someone advise as to the best way to execute commands that does not
require return values?
=20
Thanks.
=20
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.

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@source.wolterskluwer.com]=20
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=3D-1) at ./try.pl line 54.

nv01()=3D> \d b_sdl_123456_p_dlvrb_study_att
Did not find any relation named "b_sdl_123456_p_dlvrb_study_att".=20

The $sqlString is:=20

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.
=20
Peter

-----Original Message-----
From: Reidy, Ron [mailto:Ron.Reidy@arraybiopharma.com]=20
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@source.wolterskluwer.com]
Sent: Friday, June 30, 2006 1:51 PM
To: DBI-Users
Subject: sth->do()

Hi All,
=20
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.
=20
Can someone advise as to the best way to execute commands that does not
require return values?
=20
Thanks.
=20
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.

RE: sth->do()

Hi Ron,

Man, the thread is busy today. It appears that everyone is charged up
after the 4th. Welcome back everyone. :)

Back to business. I had decided to open a pipe to SQL and feed the
command to it.

eval {
open(NZSQL, "| nzsql -d $dbName -u $userid -W $passwd");=20
print NZSQL "$cmd";
}

if ($@) {
.
.
.
}

Thanks for all your input.
=20
Peter

-----Original Message-----
From: Reidy, Ron [mailto:Ron.Reidy@arraybiopharma.com]=20
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 (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@source.wolterskluwer.com]
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=3D-1) at ./try.pl line 54.

nv01()=3D> \d b_sdl_123456_p_dlvrb_study_att
Did not find any relation named "b_sdl_123456_p_dlvrb_study_att".=20

The $sqlString is:=20

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.
=20
Peter

-----Original Message-----
From: Reidy, Ron [mailto:Ron.Reidy@arraybiopharma.com]=20
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@source.wolterskluwer.com]
Sent: Friday, June 30, 2006 1:51 PM
To: DBI-Users
Subject: sth->do()

Hi All,
=20
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.
=20
Can someone advise as to the best way to execute commands that does not
require return values?
=20
Thanks.
=20
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.


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.