RE: perl and informix

Hallo, didn't you try to use the perl built-in function wait() to wait for the dbaccess proccess ending? And did you think about the proper informix in perl DBI and so on. Best regards -- -- -- -- Denis Volkov (denis.volkov@start.de) Start Amadeus GmbH Germany > ---------- > Von: samir BADAOUI[SMTP:samir_badaoui@hotmail.com] > Gesendet: Montag, 14. August 2000 22:55 > An: informix-list@iiug.org > Betreff: perl and informix > > > Hi all, > I am using PERL to access my inforix 7.30 database under AIX 4.3. I am > doing > something like : > -------------------------- > 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 ! > > ________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com >