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.
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 a
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
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 (ass
> 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
> -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:
From: Dan Werner [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 25, 2006 4:36 PM
To: 'dbi-users@perl.org'
Subject: DBI/DBD::Oracle and Oracle 10g
>
> Should it be necessary to recompile DBI and/or DBD::Oracle when
> upgrading from Oracle 9.2.0.4.0 to 10.2.0.2.0?
If only the database server was upg
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