Re: perl and informix

From: "samir BADAOUI" <samir_badaoui@hotmail.com> > >I am using PERL to access my inforix 7.30 database under AIX 4.3. I am >doing >something like : Why don't you get DBD::Informix? >-------------------------- >my $fichier = "/tmp/test" . $ENV{'INFORMIXSERVER'} . ".unl"; >my $requete = "set isolation to dirty read;unload to $fichier select >col1,col2,col3 from ... where ..."; >my $result = &dbaccess ($requete,"my_database"); ># Read each remaining line >open(REFICH,"cat $fichier |"); >my $line = ''; > >while ($line=<REFICH>) >{ >my ($col1,$col2, $col3) = split('\\|',$line); >print &list_row(td($col1), td($col2), > td($col3)); >} >close REFICH; >print &end_list('No items from this request'), >-------------------------------------- >when the sql request take some minutes, I get the message "No item from >this >reques" in my browser. That's because the perl process call a dbaccess >process to execute the request but don't wate the dbaccess process to >finish >executind the request and fill the file $fichier. >any one has any idea to resolve this prolem ????? >sorry for my bad english gays ! It really is a bummer. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com