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) 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 tuples
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
returns: 3
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? That
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
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 values are valid
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, FH line 53.
Thanks.
Peter
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:
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',
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, FH line 53.
Peter
-Original Message-
From: Loo, Peter # PHX [mailto:[EMAIL
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:
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 confess
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
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,
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 rows
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 output
/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):
snip
/usr/bin/make test -- NOT OK
Running make
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 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 to go
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, Jack
20 matches
Mail list logo
