my($dbh) = @_; my @datamodels; my %filenames; my %dbids; my $sql = "select DATAMODEL_CD, DB_ID, FILENAME from PRDRELEASE where RELEASE_FG = 1"; my $sth = $$dbh->prepare($sql) or $app->error($FATAL, "Can't do SQL statement [ $sql ] :: $DBI::errstr"); $sth->execute(); while (my @values = $sth->fetchrow_array()){ push (@datamodels, $values[0]); $dbids{$values[0]} = $values[1]; $filenames{$values[0]} = $values[2]; }#end while loop printf("@datamodels\n"); my $numelements = @datamodels; return (\@datamodels, $numelements, \%dbids, \%filenames); #### my ($datamodels, $numelements, $dbids, $filenames) = get_data(\$dbh); #### my ($dbh, $datamodel, $date, $numelements, $filenames) = @_; my $file = "$filenames{$datamodel->[$count]}" print "$file\n";