i am facing error while accesing db2 data using perl dbi on linux.
it gives a error

Cannot establish an ftp connection to host xxx.xxx.xxx.xxx at port 446. Error received: Bad file descriptor

the program i am executing is first.pl


use warnings;
use strict;
use DBI;
# All the queries will be routed to the DB2 subsystem DB2P
#
# jsmith/123456 must be a valid mainframe account able to query the tables of DB2P
#
my ($hostname,$port,$ssid) = ('xxx.xxx.xxx.xxx',446,'SHEF2282');
my ($username,$password) = ('username','password');
my $dbh = DBI->connect("dbi:MVS_FTPSQL:hostname=$hostname;port=$port;ssid=$ssid",$username,$password)
or die "Can't connect to database: $DBI::errstr\n";
#Prepares the query
my $sth = $dbh->prepare("SELECT * FROM EMPLOYE");
#Executes it
$sth->execute();
print "\tQuery results:\n================================================\n";

while ( my @row = $sth->fetchrow_array( ) ) {
print "@row\n";
}
warn "Problem in retrieving results", $sth->errstr( ), "\n"
if $sth->err( );
$sth->finish();
$dbh->disconnect();
~
~

Moderator note: I removed the IP Address and username/password from your post. It's wise not to give such details when asking for help.

As for the problem, If your connecting to DB2, why is it complaining about FTP access? A bad file descriptor problem can be numerous things, most of the time it's on the OS level or filesystem level.

thanks acctually i am new to this so did't knew not to mention those info.

regarding the problem can u plz tell me anyother way to connect to db2 on mainframes using perl on linux.

thanks.

I would imagine perl::dbi is the best way that you are using, unless you want to write your own perl code to connect.

how to access db2 on mainframes using perl on linux .
plz help i tried doing it using DBD-MVS_FTPSQL-0.38.14
but not able to do it as its giving ftp connection error

Please do not start the same discussion more than once. I've merged this new thread with your existing thread you've already started.