Re: DBD:Oracle, Redhat 7.2

2002-03-20 Thread Marcelo Guelfi
On Wed, 20 Mar 2002 14:35:56 GMT0BST "Adam Gent" <[EMAIL PROTECTED]> wrote: > Hi All, > > After attempting to install both the Oracle 8.1.7 server and > client software on my RedHat machine, I have given it up as > a bad job. It's just not happening. I've had technicians > scratching their he

Re: Download DBI as a precompile package for Windows use

2002-03-15 Thread Marcelo Guelfi
On Fri, 15 Mar 2002 13:58:01 +0100 "NYIMI Jose (BMB)" <[EMAIL PROTECTED]> wrote: > Hello, > > I've found it very handy downloading perl from www.activestate.com as pre-compile >package, ready to be used, you no longer need to (trouble :-)) perl makefile.pl, >make, ...and so on. Click and use !

Re: Improving DBD::Oracle Performance?

2002-03-14 Thread Marcelo Guelfi
On Thu, 14 Mar 2002 18:03:40 -0600 Chris Starling <[EMAIL PROTECTED]> wrote: > First question: Is there a DBD::Oracle specific mailing list I should > be posting this question to? > You can see diferences when you are inserting/deleting/updating records, but the performance of select statment

Re: Need help with map and sort

2002-03-13 Thread Marcelo Guelfi
On Wed, 13 Mar 2002 15:42:18 -0500 "Etienne" <[EMAIL PROTECTED]> wrote: > Wow this one was pretty easy with the order by :) > > Now I get my events.. > > my $res = $dbh->selectall_arrayref ("SELECT evtDate, evtName FROM events > ORDER BY evtDate"); > > I can print the first set using > > prin

Re: ::massive sql query using dbi - please help::

2001-11-02 Thread Marcelo Guelfi
1) Did you try to perform that query from mysql instead of a perl program to measure the time? 2) Is this code correct? : open (DATATEMP, ">>$data_log"); flock (DATATEMP, $exclusive_lock); print LOG "$row->[0]\t$row->[1]\n"; close (LOG); You never open

Re: Looping through recordset twice

2001-11-01 Thread Marcelo Guelfi
Don Seiler" llcom.com> cc: Marcelo Guelfi/Uruguay/Contr/IBM@IBMUY, <[EMAIL PROTECTED]> Subject: Re: Looping

Re: Looping through recordset twice

2001-11-01 Thread Marcelo Guelfi
I don't think so. Why don't you put the selected records in an auxiliary structure (hash, array) and then go through that structure? Saludos, Marcelo.

Re: DBI Install Error on AIX

2001-10-26 Thread Marcelo Guelfi
1) Do you have C already installed? You can check it running: lslpp -l | grep -i vac and see if you have the filesets. 2) If you have vac.C and you can't find in /usr/bin probably you didn't run the replaceCSET script that creates links for cc* in /usr/bin. You can find that script in /usr/

RE: How to install DBI on AIX; need DBDSybase and DBDOracle to wo rk

2001-08-17 Thread Marcelo Guelfi
I've been working with AIX, DBI and DBD::Oracle since 1998, I installed them with differents versions of AIX, Oracle, DBI, DBD::Oracle and C compilers and never had big problems. I recommend that you transfer the 'tarball' file to the AIX box and then unpack it. Some windows ftp clients don't car

RE: Data Extract

2001-06-08 Thread Marcelo Guelfi
I've been doing some test and I have found that perl scripts are faster than I used to thought and in some cases faster than C programs. The Perl script 'automagically' does bulk fetches that speed up your application a lot (well the wizard are the DBI and DBD::Oracle who do the dirty work). In a

Re: DBD-Oracle 1.0.7/AIX make problem

2001-06-07 Thread Marcelo Guelfi
I had the same problem in the past, removed that lines and it worked. Best regards, Marcelo. Tobias Hausmann <[EMAIL PROTECTED]>@br.ibm.com on 06/06/2001 19:02:49 Please respond to Tobias Hausmann <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] To: [EMAIL PROTECTED], [EMAIL PROTE

RE: Problem with DBD-Oracle-1.06

2001-06-05 Thread Marcelo Guelfi
I dont' know if you want to build the environment in HP or in IBM. You can install a brand new perl in a different directory of the already installed without any problem and then use it to compile DBI+DBD, etc. I did this before and have no problems. The only cons is that you must remember use th

Re: AIX 4.3.3 + DBD 1.06 + Oracle 8.1.6 >> Compilation problem

2001-03-02 Thread Marcelo Guelfi
You have 2 options: 1) Get gcc and gnu-make and try with them. 2) Just comment all that lines and you the program will compile without problem. I don't know if I'm missing something without that lines but my scripts work fine. Best regards, Marcelo. "Stephane Barde" <"stephan

Re: Problem with fetching rows and date columns

2001-02-27 Thread Marcelo Guelfi
gt; Sent by: [EMAIL PROTECTED] To: Marcelo Guelfi/Uruguay/IBM@IBMUY cc: [EMAIL PROTECTED] Subject: Re: Problem with fetching rows and date columns >>>>> "Marcelo" == Marcelo Guelfi <[EMAIL PROTECTED]> writes: Marcelo> I'm having problems to fetch

Problem with fetching rows and date columns

2001-02-26 Thread Marcelo Guelfi
I'm having problems to fetch rows when the 'select' clause has a where condition with 'date' types columns. Basically, it doen´t fetch anything when a date value is passed in the execute method. Trying to figure out where the problem is I wrote another program that obtains rows from a table and