my $dbh = DBI->connect( 'DBI:ODBC:ALIAS', $username, $password);
    my $stmt = $dbh->prepare('SELECT * FROM SCHEMA.TABLE');
    $stmt->execute();
    ...