I just wanted to unload the data from informix database table into a text file with pipe delimiter. Which worked similar to dbacces "unload" command.
my $dbh1= DBI->connect("DBI:Informix:$dbname","","")
or die " cannot connect to Informix DB\n";
my $sth1 =$dbh1->prepare("select * from table");
Thanks in advance