Hello,
I'm using the latest release of DBD::DB2 module(v0.75) and DB2
v7.1 on windows 2000.
I added those lines in db2cli.ini as you advised, but nothing happend.
After i runned my script trace file didn't appear. I tried to
reboot, but i got the same result...
BTW, i found db2cli.ini only in the root of DB2 installation
and there is no sqllib directory.
Maybe i'm doing smth wrong ? Do DB2 fixpack's have any importance
in this problem ? For a while i didn't install any of them,
but if it helps i'll download that 250M with FP3.
dcic> Hi Alex, what version of DBD::DB2 are you using? If you are not using the
dcic> latest (0.75) please upgrade. If you are, then please send me a CLI trace
dcic> of the failure. Add this to db2cli.ini (sqllib\db2cli.ini on Windows,
dcic> sqllib/cfg/db2cli.ini on Unix):
dcic> [common]
dcic> trace=1
dcic> traceflush=1
dcic> tracepathname=<some path>
[...]
dcic> I'm trying to fetch data from 2 stored procedures one after
dcic> another and i'm getting weird error message when it start to
dcic> fetch from second one. Here is a code snippet
dcic> ----
dcic> my $sth1 = $dbh->prepare("call sp_Get_Buildings()");
dcic> $sth1->execute();
dcic> my $sth2 = $dbh->prepare("call sp_Get_Streets()");
dcic> $sth2->execute();
dcic> print "1st sth" while($sth1->fetch);
dcic> print "2nd sth" while($sth2->fetch);
dcic> ----
dcic> On last line it writes
dcic> ---
dcic> DBD::DB2::st fetch failed: [IBM][CLI Driver] CLI0125E Function se
dcic> quence error. SQLSTATE=HY010 at 1.pl line 12.
dcic> ---
dcic> I already found several solutions for this - place each out after
dcic> corresponding while($sth->fetch), but it isn't suit for me, cos in
dcic> real project i have to at first prepare each $sth and only then do
dcic> smth with them. Another solution is to replace call to stored
dcic> procedure by SQL statement itself, but i think it's not good...
dcic> So, here are a couple of questions:
dcic> 1. What does that error message mean ?
dcic> 2. How i can get rid of it ?
dcic> Thanks in advance.
--
Best regards,
Alex mailto:[EMAIL PROTECTED]
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
