On Thu, May 25, 2006 at 04:03:39PM -0400, Peter Halliday wrote:
Tim and Thomas,
Not sure why this is the case, but I noticed that doing an insert with
an execute via DBD::Multiplex didn't work when using text that
contained latex for example. But a do with the same did work.
What kind of
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]
Sent: Friday, May 26, 2006 3:52 AM
To: Peter Halliday
Cc: 'Tim Bunce'; dbi-users@perl.org; [EMAIL PROTECTED]
Subject: Re: Problem with DBI::Multiplex
On Thu, May 25, 2006 at 04:03:39PM -0400, Peter Halliday wrote:
Tim
So $sth-execute(@_); didn't work,
but
my @tmp = @_;
$sth-execute(@tmp);
did?
It was more like this
$sth-execute(@_) didn't work
$sth-execute() did.
Peter Halliday
Excelsior Systems
http://www.excelsiorsystems.net
(Phone:) 607-936-2172
(Support:) 607-329-6905
I would only add that I believe the to_char method is more expensive
because you are taking temporal data, converting it to a string
representation and then doing a string comparison. Really not a big
deal but this can be quite expensive with large data sets. Then again
with a large data set
Hi All,
I have an interesting requirement and am hoping that I can obtain a
solution here.
I have the need to get several billion rows from multiple Oracle tables
to tables on a Netezza database. I have tried several ways to get the
data over to Netezza using Perl DBI by opening two database
Loo, Peter # PHX wrote:
Hi All,
I was wondering if anyone might have an answer as to how I can sync the
start up of the write and INSERT INTO at the same time or perhaps some
other method.
named pipe - good idea - on nfs - bad idea
take a look at netcat, socat, tcpclient tcpserver
Ian,
Thank you for your input. This solved the other problem. The other problem
was the query took to long to complete. I did not know that putting
functions on the left side of compare statements caused full table scans.
Great advice.