ANNOUNCE: SQL::Statement Version 1.005

I have uploaded the latest vesion of SQL-Statement to CPAN. All users of SQL-Statement, SQL-Parser, DBD::CSV, DBD::AnyData, DBD::Excel and other modules using SQL::Statement are encouraged to upload the file from: http://www.cpan.org/modules/by-authors/id/J/JZ/JZUCKER/SQL-Statement-1.005.tar.gz

DBI Query

Hi, I am facing a problem while trying to connect to MS access database using ODBC through perl, below is the error. I have a Windows 2000 workstation and I have configured the ODBC driver for MS Access database. Can't locate loadable object for module DBI in @INC (@INC contains: c:\perl\lib c:

ld.so.1 error

Hi All, I am getting the following error: bash-2.03# /opt/bin/perl5.8.0 CONNECT_TEST.pl ld.so.1: /opt/bin/perl5.8.0: fatal: relocation error: file /opt/perl5/lib/site_perl/5.8.0/sun4-solaris/auto/DBD/mysql/mysql.so: symbol mysql_init: referenced symbol not found While trying to connect

Re: DBD::CSV and multiple table queries

"Jeff Zucker" <[EMAIL PROTECTED]> wrote in message news:3DB98694.8080701@;vpservices.com... > Yes, there is a bug in SQL::Statement related to table names combined with a column name (e.g. megaliths.id). > > I will be releasing a fix later today. Thank you oh great and wise one! I appreciate the h

Re: DBI with DBD::Pg memory issues with large result set?

Juha-Mikko, Thanks for that -- I had arrived at the same conclusion after touring through the DBD code and forming the hypothesis that it did not do the pre-fetching (and therefore it must have been PostgreSQL -- have I got this right?). However, I looked through the PostgreSQL docs and could fin

RE: Oracle /Perl Access Speed Optimization

Bharat, first two important notices from Oracle tuning guides : "If you want to tune your database, don't do it" "If you want to increase performance, you have to find the bottleneck" Next a few hints where you can start tuning your database : use "explain plan"(see Oracle docs) to see wether

Re: DBI with DBD::Pg memory issues with large result set?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Saturday 26 October 2002 00:29, Mike Nielsen wrote: > The "execute" seems to be returning all the rows into the address > space of my program. Since the result set is ~4 million rows, this > has diabolical consequences on memory and, in fact, the p