Martin,
thanks for your reply.
as to the version of unixodbc, I use what is part of SuSe 9.2:
Name: unixODBC Relocations: (not relocatable)
Version : 2.2.9 Vendor: SUSE LINUX AG, Nuernberg, Germany
Release : 4 Build Date: Mo 04 Okt 2004 22:49:44
Is
Quoting Walter Obermiller [EMAIL PROTECTED]:
Martin,
thanks for your reply.
as to the version of unixodbc, I use what is part of SuSe 9.2:
Name: unixODBC Relocations: (not relocatable)
Version : 2.2.9 Vendor: SUSE LINUX AG, Nuernberg, Germany
Hi all,
I need some equivalent of func() function in db2.
In this function I am calling dbms_output_enable(), dbms_output_put()and
Dbms_output_get().
These are available in dbd:oracle package but not in dbd:db2.
Example : $dbh-func('dbms_output_get');
How to use this in db2? Is there any
Martin, thanks.
I checked. my unixodbc is indeed threaded.
The driver library however, is not:
/usr/local/lib/odbclib.so
/lib/libNoVersion.so.1 = /lib/libNoVersion.so.1 (0x400a9000)
linux-gate.so.1 = (0xe000)
libsqlrte.so = /usr/local/lib/libsqlrte.so (0x400ce000)
libm.so.6 =
The DontDlClose was a suggestion to stop the seg faulting on exit.
When I said you can use DSN=emanuel-sbart;UID=*;PWD=*; I did of course mean to
say you need to keep the 'dbi:ODBC' on the front. i.e.
'dbi:ODBC:DSN=emanuel-sbart;UID=*;PWD=*;'
Martin
--
Martin J. Evans
Easysoft Ltd, UK
Hi all,
I have table which consist of cca 20.000.000 rows, using MySQL.
How to do something with each row ? I mean: I can't select them
all into memory, I can't use LIMIT, because it is slow at higher
values, so what is good to use ?
I think about:
select id, name from table where id 100
and
Use and toss ... Use and toss.
While ( (@data) = $query-fetchrow_array)
{
... Do stuff to data ...
... Do updates to data ...
... Rinse and repeat ...
}
-Original Message-
From: Ing. Branislav Gerzo [mailto:[EMAIL PROTECTED]
Sent: Tuesday,
Jones Robert Civ TTMS Keesler [JRC], on Tuesday, February 22, 2005 at
07:18 (-0600) typed:
JRC Use and toss ... Use and toss.
JRC While ( (@data) = $query-fetchrow_array)
no, I can't use it, when i call execute() it will fill all my memory.
also $dbh-selectrow_array doesn't
I think we need to see more information to understand why this is
happening.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 22, 2005 7:32 AM
To: DBI-Users
Subject: Re: retrieve many values
Ing. Branislav Gerzo [IBG], on
Your code looks very suspect, see below.
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tue 2/22/2005 6:31 AM
To: DBI-Users
Cc:
Subject:Re: retrieve many values
Ing. Branislav Gerzo [IBG], on
Martin,
Martin J. Evans wrote:
The DontDlClose was a suggestion to stop the seg faulting on exit.
When I said you can use DSN=emanuel-sbart;UID=*;PWD=*; I did of course mean to
say you need to keep the 'dbi:ODBC' on the front. i.e.
'dbi:ODBC:DSN=emanuel-sbart;UID=*;PWD=*;'
blush :-)
I have fixed
Reidy, Ron [RR], on Tuesday, February 22, 2005 at 06:58 (-0700) wrote:
my $sth = $dbh-prepare_cached(select id, name from table);
my $sth = $dbh-$sth-execute();
RR [rr] This should read $sth-execute. Execute retruns a
RR value, not a statement handle ($sth).
yes, sorry for that. In my code I
Mysql will return all rows by default, you need to turn that off.
I can't remember what the attribute is, read the DBD::mysql perldoc.
On Tue, 2005-02-22 at 15:22 +0100, Ing. Branislav Gerzo wrote:
Reidy, Ron [RR], on Tuesday, February 22, 2005 at 06:58 (-0700) wrote:
my $sth =
I found it,
Note, that most attributes are valid only after a successfull
execute.
An undef value will returned in that case. The most important
excep-
tion is the mysql_use_result attribute: This forces the driver
to use
mysql_use_result rather than
Scott [EMAIL PROTECTED] recently wrote (in part):
... personally would not use it. It is perl 5.6.1. I like to stay
more current.
That was my first reaction too, but the sys admins and DBAs think
that we might run into fewer problems by sticking with what
appears to be
On 22-Feb-2005 Walter Obermiller wrote:
Martin,
Martin J. Evans wrote:
The DontDlClose was a suggestion to stop the seg faulting on exit.
When I said you can use DSN=emanuel-sbart;UID=*;PWD=*; I did of course mean
to
say you need to keep the 'dbi:ODBC' on the front. i.e.
Scott T. Hildreth [STH], on Tuesday, February 22, 2005 at 08:36
(-0600) thinks about:
STH Mysql will return all rows by default, you need to turn that off.
STH I can't remember what the attribute is, read the DBD::mysql perldoc.
I do everything, but I cannot find that. I looked in
Scott T. Hildreth [STH], on Tuesday, February 22, 2005 at 08:50
(-0600) wrote the following:
STH my $sth = $dbh-prepare(QUERY);
STH $sth-{mysql_use_result} = 1;
thanks a lot, you save me a day! :)
--
...m8s, cu l8r, Brano.
[Foiling felons and thwarting thieves. - DarkWing
Scott T. Hildreth [STH], on Tuesday, February 22, 2005 at 08:50
(-0600) typed the following:
STH my $sth = $dbh-prepare(QUERY);
STH $sth-{mysql_use_result} = 1;
this is indeed nice, but solve problem only half. When I process
value I want insert/update it to db. But I get, when
Martin,
thanks for your patience.
Martin J. Evans wrote:
On 22-Feb-2005 Walter Obermiller wrote:
Martin,
Martin J. Evans wrote:
The DontDlClose was a suggestion to stop the seg faulting on exit.
When I said you can use DSN=emanuel-sbart;UID=*;PWD=*; I did of course mean
to
say you need to keep
Ing. Branislav Gerzo [IBG], on Tuesday, February 22, 2005 at 13:06
(+0100) wrote these comments:
IBG but it is good way ? It will not consume memory ?
I'll try to be more exact:
when I run this code:
my $sth = $dbh-prepare_cached(select id, name from table);
my $sth = $dbh-$sth-execute();
it
Jones Robert Civ TTMS Keesler [JRC], on Tuesday, February 22, 2005 at
07:18 (-0600) typed:
JRC Use and toss ... Use and toss.
JRC While ( (@data) = $query-fetchrow_array)
no, I can't use it, when i call execute() it will fill all my memory.
also $dbh-selectrow_array doesn't
I'd certainly use -w:
Note: perl is running without the recommended perl -w option
There appears to be a bit missing from your trace. It should show
something like:
Driver connect 'DSN=test;uid=Martin_Evans;pwd=easysoft;', '', ''
after
dbih_setup_attrib(DBI::db=HASH(0x8248c00),
Martin,
this is because as I said in my last mail, the program
loses itself in an endless loop. The sql.log file (20 mb) for this
execution shows a couple of zillion messages complaining about the
adabas driver receiving an empty password
The question is: what is tacking an empty UID=;PWD=;
24 matches
Mail list logo