my $db11 = "DC:server1";
my $dbor = "DC:server2";

    FROM openquery([$db11], N\'
        SELECT
            r.ReqID
            , de.varc_EmploymentPriority
            , d.candidateid
            , d.FirstName + \'\' \'\' + d.LastName
            , r.sHiringManager
            , d.DossierType

    \') as hc join openquery([$dbor], N\'
        SELECT
            p.first_name
            , p.last_name
            , c.id
            , replace(replace(dbms_lob.substr(a.answer,4000,1),chr(10), \'\' \'\'),chr(13), \'\' \'\') as "Answer"
            , replace(replace(dbms_lob.substr(ql.question,4000,1),chr(10), \'\' \'\'),chr(13), \'\' \'\') as "Question"
            , CASE ql.type