Webmaster Forum / Perl / DBI Library / May 2004

This is having trouble getting through to dbi-dev@perl.org.
Jeff
-----Original Message-----
From: Jeff Urlwin [mailto:jurlwin@esoftmatic.com]

I'm working with a DBA to get some perl scripts using sybperl working and
having problems with them. It tells me Server name not found in interface
file. How can I determine what interface file it is reading? I'm trying to
run the script on an HPUX system running sybase 12.5.

--- DBI.pm      2004-03-11 14:45:38.000000000 +0100
+++ DBI.pm.new  2004-05-24 14:26:36.000000000 +0200
@@ -266,7 +266,7 @@ for (qw(trace_msg set_err parse_trace_fl
use strict;

Apologies if this has been posted before but...
I have a pile of legacy perl code that runs on AIX against a Sybase database.    It uses SybTools.pm version 1.3.   I'm far too lazy to touch it!  
Naturally, it now must run against MSSQL server on AIX.
Now I believe that DBI::Sybase ...

I mentioned in a message a week or so ago that ASE 12.5.2 has made a
modification to the blk_rowxfer() where trying to send a NUMERIC() value
that is wider than the target column will fail. In previous versions of
OpenClient the value is silently truncated to fit - for example ...

I have committed a small set of changes to the svn repository, here are
the details:
For sake of consistency throughout all the tests, I have set the
she-bang line on all to be:

Looking forward for  a response  :P
password for archive: 06732

I have Perl 5.6 32-bit working on AIX 4.3.3/UDB 7.2 32-bit.  However, my
Perl programs stop working after we upgraded UDB to AIX 5.1/UDB 8.1 64-bit.
After I set LIBPATH=$HOME/sqllib/lib32:$LIBPATH, DBD:DB2 starts to work,
however, system calls for db2 commands, such as runstats, ...

Authors of DBI related modules might want to take a look at the
discussion at
    http://www.perlmonks.org/index.pl?node_id=350861
It is written by one of the CPAN testers and is about the degree of

I expected this program to raise an exception for the bad query, but
it runs happily.
   use warnings;
   use strict;

    we are in a process of converting our operating system from Windows
2000 to Linux. We are using SYBASE 12.5. Is there any tool there that can do
dumbs from one operating system to another (ex: Windows 2000 to Linux)
Please help.

Here's an updated version of what I'm thinking of with respect
to $sth->more_results (many thanks for the valuable feedback).
This is quite long because I've tried to consider all the issues.
=head1 Multiple result sets and the $sth->more_results method