On 24/06/06, Jonathan Leffler [EMAIL PROTECTED] wrote:
On 6/23/06, [EMAIL PROTECTED] [EMAIL PROTECTED]
wrote:
snip
If you have a pre-compiled module, then I think your problem is the absence
of DB2 Connect (IIRC) or its equivalent.
snip
The basic connectivity requirement for DBD::DB2 on
WAG here: will the DBD::DB2 driver implicitly finish the resources if
you try calling $sth-fetchrow_array() again?
I don't know if DBD::DB2 can know whether there are more rows left in
the result set until you try fetching the next row, ergo it keeps the
statement handle active.
Dan
On
Hi Martin:
You'll need the Application Development Client, which is a free
download from http://ibm.com/db2/udb/support/downloadv8.html.
The clients are installed as RPMs on Linux using the db2setup program
(part of the client); you might want to check out the DB2 HOWTO
This is a nice thought, but the latest release of DBD::DB2 is actually
0.78 (released a long time ago), but ActiveState wasn't interested in
updating their version of the package because DBD::DB2 prereqs the DB2
Runtime Client.
Apparently ActiveState has made it a policy to avoid offering
Seems to be working now for me: http://ftp.esoftmatic.com/outgoing/DBI/
Dan
On 31-Jan-2006 10:09:34 CET, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
Hello,
I need DBI and DBD-DB2 packages for Activeperl, but esoftmatic server is
unreachable.
Can anybody help me with this problem or send me
Hi Vincent:
You just need to install the DB2 development headers and libraries
(available with the free to download and use DB2 Application
Development Client) on your Linux box and set DB2_HOME before
compiling DBD::DB2; that will enable you to connect from your Linux
box to a DB2 server running
on
windows box or?
Thanks in advance
On 1/5/06, Dan Scott [EMAIL PROTECTED] wrote:
Hi Vincent:
You just need to install the DB2 development headers and libraries
(available with the free to download and use DB2 Application
Development Client) on your Linux box and set DB2_HOME before
On 11/16/05, Rob Craig [EMAIL PROTECTED] wrote:
I am using DBD::mysql and I can get the number of rows by assigning the
result of the execute to a scalar:
my $rows = $sth-execute or die Couldn't execute statement: .
DBI-errstr;
maybe this doesn't work with DBD::Oracle?
Rob
When you
Strange -- just tried the exact same commands here and they worked as
expected. Maybe there was a temporary FTP server glitch.
Are you able to see the ftp.esoftmatic.com site?
Dan
On 11/3/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hello.
I just installed perl 5.8.7 from active state. (I
Hi Darren:
I think an update about the recommended minimum database version
levels for your access modules is on-topic for this mailing list, but
suspect that product advertisements are probably off-topic -- personal
opinion, maybe, but I don't want to see this list become a dumping
ground for
DBD::DB2 (http://search.cpan.org/dist/DBD-DB2/DB2.pod) supports
bind_param_inout,
but it would require you to use the DB2 Connect Personal Edition or DB2 Connect
Unlimited for iSeries to access iSeries from your Linux, UNIX, or Windows box.
Dan
On 10/12/05, Stephen More [EMAIL PROTECTED] wrote:
If you're willing to upgrade to Perl 5.8.x, then you can use the
latest available version of DBD-DB2 from
http://ftp.esoftmatic.com/DBI/ (it's okay to install the 5.8.4 version
of DBD-DB2 on Perl 5.8.7).
Dan
On 10/7/05, Trent Ohannessian [EMAIL PROTECTED] wrote:
Hello,
I currently have Perl
[EMAIL PROTECTED] wrote:
Hello,
I'm now using Perl 5.005, DBI-1.15, DBD-DB2-0.75 on AIX 4.3.
And like to upgrade them to Perl 5.8, DBI-1.48, DBD-DB2-0.78.
Installation may be ok, but when I INSERT double bytes characters,
I get the following error.
[IBM][CLI Driver] CLI0109E String data
Dan Scott wrote:
Alec Brecher wrote:
My DBD-DB2 installation on Fedora Core 3 is failing because it cannot
find libdb2.so.1.
The Application Dev client is installed and works fine. The
DB2_HOME=/home/db2inst1/sqllib
I saw some post from Owen Berry on another list regarding this issue.
His
Alec Brecher wrote:
My DBD-DB2 installation on Fedora Core 3 is failing because it cannot
find libdb2.so.1.
The Application Dev client is installed and works fine. The
DB2_HOME=/home/db2inst1/sqllib
I saw some post from Owen Berry on another list regarding this issue.
His fix: add
Tim Bunce wrote:
On Fri, Sep 02, 2005 at 05:37:57PM -0500, johnn wrote:
Capacio, Paula J wrote:
my $stmt = 'select count(*) from sysibm.badTblnm ';
my $sth = $dbh-prepare($stmt) or die Prepare Failed\n;
DBD::DB2 doesn't seem to return false values for failures.
If that's true then
On 7/19/05, Keith Jackson [EMAIL PROTECTED] wrote:
I have a project that I need to connect to a DB2 database on an AS400
from a perl application on a Linux box. I've been reading as much as I
can but have a few questions for those with experience in a similar
task.
My options appear to be
Chris:
This sounds very much like the problem noted under Hints at
http://www-306.ibm.com/software/data/db2/perl/:
Having trouble running perl with DB2 UDB Version 8 64-bit for AIX
5.2? Check out this technote.
For the DSN-less connections, see http://www.connectionstrings.com --
great resource.
Dan
On 6/2/05, Martin J. Evans [EMAIL PROTECTED] wrote:
Sharon,
The string after ODBC: is usually a DSN name as in:
DBI-connect(dbi:ODBC:mydsn,...)
or
DBI-connect(dbi:ODBC:DSN=mydsn)
where mydsn
This is not the mailing list you're looking for. This mailing list is
specifically about using the Perl DBI with the associated database
drivers (for example, the DBD::DB2 driver, as documented at
http://ibm.com/db2/perl/).
If you want help calling Java applications from a shell script, you
would
There is an archive of older ActiveState Perl releases at
http://downloads.activestate.com/ActivePerl that includes 5.8.4.
Dan
On Mon, 14 Mar 2005 09:01:24 -0500, Marina Greenstein
[EMAIL PROTECTED] wrote:
Jeff,
Any chance you will update repository with 5.8.6 binaries ? Or please let
On Thu, 02 Dec 2004 08:53:38 +0100, Cosimo Streppone
[EMAIL PROTECTED] wrote:
Tim Bunce wrote:
I know what it does, I'm trying to find real examples that demonstrate
why people think it's needed. Nick has provided a good one. Any others?
Something like DBIx::DBH is in use in our
On Mon, 8 Nov 2004 15:17:34 +0100, Miroslav Lau [EMAIL PROTECTED] wrote:
Hi all!
I'm using DBD::DB2 to access remote DB2 database on an AS400 machine. I've
managed it to work from command line.
But when trying to connect to remote database from a mod_perl application the
$DBI::errstr is
Ben:
DB2 automatically takes the user ID you logged in with and uses that
as your default schema.
You can issue the SET SCHEMA statement to change your default schema
if you want it to be different from your DSN user ID. For example SET
SCHEMA rick would automatically prepend 'rick.' to all of
ricardo Guerra Flores wrote:
Hi all...
i'm having some problems trying to run a script that uses DBD::DB2 inside
mod_perl and the Apache::DBI module, the program runs right when i execute
it as a stand alone perl program. I've already set the ENV for db2home,
db2instance, etc. in startup.pl
This
25 matches
Mail list logo