my $sql = "SELECT * FROM ORG1.MACHINE"; ## SQL works in MySQL studio where ORG1:db and MACHINE:table my $sth = $dbh->prepare($sql); $sth->execute(); ## should I be sure to inject (undef) my ($ID, $NAME, $USER, $MAC); ## Titles correspond to Schema Viewer table names in CAPS #BIND results to variables ? $sth->bind_columns(undef, \$ID, \$NAME, \$USER, \$MAC); ##retrieve / return results while( $sth->fetch() ) { print "$ID, $NAME, $USER, $MAC\n"; } $sth->finish(); $dbh->disconnect();