If you want the information about the column , like its type etc., don't do it by running an external program, but do it by using the catalog methods. What you want is basically:

use DBI;
my $dbh = DBI->connect('dbi:DB2', 'db2tf0' );
my $sth_columns = $dbh->column_info(undef, undef, 'indic.name', undef)
+;
# print out the results
[download]

If you really cannot use DBI and your system administrator won't install it, maybe you can simply pipe text into the db2 shell instead of trying to run things interactively:

my @results = qx(echo 'connect to ctinld01 user db2tf0 using db2tf0\nd
+escribe select * from indic.name' | db2 );
print "<$_>" for @results;
[download]

According to the db2 manual, you can simply pass the SQL statement(s) to the db2 tool:

db2 "connect ..." "select ..."
[download]