Infact, though I did have the db software installed I did NOT have any
databases cataloged or aliased. Would that be the issue?
On 9/5/06, Jack Faley ( The Tao of Jack ) <[EMAIL PROTECTED]> wrote:
On 9/5/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
>
>
>
> On Sep 5, 2006, at 8:32 PM, J
On 9/5/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
On Sep 5, 2006, at 8:32 PM, Jack Faley ( The Tao of Jack ) wrote:
> For what its worth ( not a whole lot), my make test failed on those
> same
> t/72childhandles ( AIX 5.2, perl 5.6?? - i can verify tomorrow if
> wanted).
> I decided
For what its worth ( not a whole lot), my make test failed on those same
t/72childhandles ( AIX 5.2, perl 5.6?? - i can verify tomorrow if wanted).
I decided to go on despite the errors and had no problems.yet. Mostly
because Im in design/test phase.
my make install went without error.
On
/usr/bin/perl -MCPAN -e 'install "DBI"'
it downloads the new module, builds everything, and then starts running
the make test portion of the install. During this process, I get the
following output (after a bunch of other successful tests):
/usr/bin/make test -- NOT OK
Running make insta
Hi, I'm having troubles trying to upgrade the DBI module in Perl. When I
do the following (as root):
/usr/bin/perl -MCPAN -e 'install "DBI"'
it downloads the new module, builds everything, and then starts running
the make test portion of the install. During this process, I get the
following outpu
On 9/5/06, Darin McBride <[EMAIL PROTECTED]> wrote:
On Tuesday 05 September 2006 10:14, you wrote:
> On 9/5/06, Darin McBride <[EMAIL PROTECTED]> wrote:
> > On Monday 04 September 2006 22:28, Jack Faley ( The Tao of Jack )
wrote:
> > I don't see it being a DBA question - it's a machine resource
Well, I've gotten a very greatdeal further. The DB people pointed me at
a test system that still had scott/tiger and opened up that account's
permissions so it could create the necessary test tables.
It's down to one warning and one error now; the gist of it is these two
lines (no doubt folded by
On Tue, 2006-09-05 at 20:36 +0100, Tim Bunce wrote:
> On Tue, Sep 05, 2006 at 02:10:24PM +0100, Martin J. Evans wrote:
> > >
> > > The DBIs default behaviour is the official behaviour.
> >
> > That is fair enough. I wasn't really suggesting it was changed, it was more
> > of
> > a pointing out t
On Tue, Sep 05, 2006 at 02:10:24PM +0100, Martin J. Evans wrote:
> >
> > The DBIs default behaviour is the official behaviour.
>
> That is fair enough. I wasn't really suggesting it was changed, it was more of
> a pointing out the inconvenience in case it led to a better way for me to get
> the r
I think you would be wise to ask Netezza SQL who wrote the ODBC driver
as they should be able to tell you what the error means. This is not a
driver I know.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
On Tue, 2006-09-05 at 12:29 -0700, Loo, Peter # PHX wrote:
> Hi Martin,
Error on page 31 of DBI_WhatsNewTalk_200607.pdf - the title has:
DBD::PurePerl instead of DBI::PurePerl.
Good slide talk. Thanks.
Boyd
T. Boyd Moore
KO4WK
Jeremiah 29:11
On Sep 4, 2006, at 7:05 AM, Tim Bunce wrote:
file: $CPAN/authors/id/T/TI/TIMB/DBI_AdvancedTalk_200608.pdf
size: 48654
Hi Martin,
Here it is. I have removed the host names.
$ cat /usr/local/etc/odbc.ini
[ODBC]
DebugFile = /tmp/oplhsodbc.log
TraceFile = /tmp/ihsodbc.log
Trace = 1
[ODBC Data Sources]
[AB01]
Driver= /usr/local/nz/lib/libnzsqlodbc.so
Description = NetezzaSQL ODBC
Servername
On Tue, 2006-09-05 at 12:09 -0700, Loo, Peter # PHX wrote:
> Martin,
>
> Here is the version:
>
> $ perl -M'DBD::ODBC' -le 'print $DBD::ODBC::VERSION'
> 1.13
>
> Peter
What I meant is what ODBC driver are you using? If you are not sure look
in your odbcinst.ini and odbc.ini files. I have to c
Martin,
Here is the version:
$ perl -M'DBD::ODBC' -le 'print $DBD::ODBC::VERSION'
1.13
Peter
-Original Message-
From: Martin J. Evans [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 05, 2006 11:45 AM
To: dbi-users@perl.org
Subject: RE: :ODBC::st execute failed: [unixODBC]ERROR: c
On Tue, 2006-09-05 at 12:34 -0600, Reidy, Ron wrote:
> So, which is it - errors at 3.8M rows, or 350K rows? When you get
> errors at 350K, are you array fetching or row-at-a-time fetching? What
> does -1 mean in the error message?
I can't tell what driver Peter is using because it has not insert
Hi Ron,
I am not array fetching, instead, I am using $sth->bind_columns with the
while ( $sth->fetch() ). Earlier, I did not even get to the while loop
before it failed with "Out of memory" error. Now it is failing with a
fetch error approximately after about 350,000 rows.
Peter
-Origina
So, which is it - errors at 3.8M rows, or 350K rows? When you get
errors at 350K, are you array fetching or row-at-a-time fetching? What
does -1 mean in the error message?
-Original Message-
From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 05, 2006 12:15 PM
To:
Now I am getting the following error after fetching approximately
350,000 rows.
DBD::ODBC::st fetch failed: [unixODBC] (SQL-)(DBD: st_fetch/SQLFetch
err=-1) at /usr/local/apps/ppv/devl/bin/sdl.pl line 228, line 53.
Peter
-Original Message-
From: Loo, Peter # PHX [mailto:[EMAIL PROTECT
Hi Ron,
I am returning approximately 3.8 million rows. Here is the code:
$sqlString = qq{ select distinct x.ptnt_gid, x.prdct_gid,
x.rx_fill_dte,
x.claim_gid, x.ovrd_days_sply_nbr,
x.clfsn_grace_prd_nbr, 'N',
Sure,
What are you doing in GlabalRoutines.pm at line 88? Are you fetching a
large result set into memory (hash or array)?
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 05, 2006 11:38 AM
To: DBI-
Hi,
Will you kindly tell me what this error message is talking about?
DBD::ODBC::st execute failed: [unixODBC]ERROR: crossed reserve : Out of
memory
(SQL-HY000)(DBD: st_execute/SQLExecute err=-1) at
/usr/local/apps/common/devl/bin/GlobalRoutines.pm line 88, line 53.
Thanks.
Peter
On 05-Sep-2006 Martin J. Evans wrote:
>
> On 05-Sep-2006 Tim Bunce wrote:
>> On Tue, Sep 05, 2006 at 11:20:04AM +0100, Martin J. Evans wrote:
>>>
>>> I'll report the problems just as soon as I'm certain what they are. Here is
>>> my summary:
>>>
>>> 1. insert into table values (?,?) where all v
On Monday 04 September 2006 22:28, Jack Faley ( The Tao of Jack ) wrote:
> Thank you for your reply. If their was any way to mitigate the small exits
> I would do it but I'm modifying an app that was never meant to be
> extensible. So, you are correct, Im moving the load to a daemon in the
> middle
Tim Bunce [mailto:[EMAIL PROTECTED] wrote:
> How about adding total rows affected as an extra return value in list
> context?:
>
> ($tuples_executed, $rows_affected) = $sth->execute_array(...)
How do you determine total rows affected? Is it simply the sum of rows
affected for each tuple? Th
On 05-Sep-2006 Tim Bunce wrote:
> On Tue, Sep 05, 2006 at 11:20:04AM +0100, Martin J. Evans wrote:
>>
>> I'll report the problems just as soon as I'm certain what they are. Here is
>> my summary:
>>
>> 1. insert into table values (?,?) where all values are valid and 3 rows of
>>values
>>
>>
On Tue, Sep 05, 2006 at 11:20:04AM +0100, Martin J. Evans wrote:
>
> I'll report the problems just as soon as I'm certain what they are. Here is
> my summary:
>
> 1. insert into table values (?,?) where all values are valid and 3 rows of
>values
>
> returns: 3
>(correct as 3 tup
On 04-Sep-2006 Tim Bunce wrote:
> On Mon, Sep 04, 2006 at 05:21:17PM +0100, Martin J. Evans wrote:
>>
>> It did raise an issue where I could do with some clarification. The slides
>> say:
>>
>> Execute a statement for multiple values
>>$sth = $dbh->prepare("insert into table (foo,bar) value
27 matches
Mail list logo
