RE: How do I check the version of DBI and DBD modules in my perl environment?

2004-06-09 Thread michael . krips
Hi David, >How do I check the version of DBI and DBD modules in >my perl environment? this will show you your version numbers: perl -mDBD::Oracle -e'print"DBI: $DBI::VERSION\nDBD: $DBD::Oracle::VERSION\n"' >Also, can anyone point me to the place where bug fixes >for various releases are kep

W32.Novarg.A@mm

2004-02-05 Thread michael . krips
Hi Tim, recently I got a mail from our administration that a '[EMAIL PROTECTED]' send me a mail with 'message.zip' attached to it containing the mail worm [EMAIL PROTECTED] I can't belive you sent it. What about that? bye mike

Performance of CSV Databases

2003-05-29 Thread michael . krips
Hi, in some cases one don't need really high performance but a well organized place to store data. In this case DBD::CSV may could be the solution. But what happens if the amount of data grows? Is there any performance comparision between DBD::CSV based applications and others (like DBD::Oracle o

RE: table descriptions via DBD::Oracle

2002-07-24 Thread michael . krips
John, try select COLUMN_NAME, DATA_TYPE, DATA_LENGTH, DATA_PRECISION, NULLABLE from USER_TAB_COLUMNS where TABLE_NAME=''; You have to execute the statement and fetch the result set like any other select statement. This is a table of the oracle data dictionary. It contains all col

How to check a DBI installation?

2002-07-18 Thread michael . krips
Hi there! For test purposes I tried to execute a perl prog at a customers solarix box, which dumps an informix table to STDOUT. It failed, because perl didn't find the DBI.pm . I found some DBI/DBD::Informix related files in /usr/informix/tmp/perl/... .. Because I'm not very experienced

DBD::Informix error -479

2002-07-12 Thread michael . krips
Dear Reader, now, I'm in a project which uses DBI (V1.3) and DBD::Informix (v0.6) and we have a serious problem: The customers db tables have an awfull design. Sometimes the tabels contain hundrets of columns!!! At beginning writing a convinience modul for db access, we got following inform