Hola, tengo la siguiente función:
sub getSectionDescription {
my $section_code = shift;
my $dbh = &EMIS::Database::gethandle('CEICP');
my $sql = '';
my $sth = undef;
my $row = {};
my $section_name = undef;
if ($dbh) {
$sql = " SELECT SECTION_NAME \n";
$sql.= " FROM LAYOUT_PATHTREE_MVS \n";
$sql.= " WHERE NODE_CODE = '$section_code' \n";
$sth = $dbh->prepare($sql);
$sth->execute;
# foreach ($row = $sth->fetchrow_hashref()) {
# push @{$section_name}, $row;
# }
$sth->finish();
$dbh = releaseDBHandler($dbh);
$section_name ...