Help for this page

Select Code to Download


  1. or download this
    while (!eof(INPUT)) {
       $record = <INPUT>;
    ...
       }
       $DB->doQuery($report->{insertSQL}, $reportDate, @records);
    }
    
  2. or download this
    sub doQuery {
       my $self = shift;
    ...
        
       return $self;
    }
    
  3. or download this
    INSERT INTO QID.dbo.ReportT52 (report_date, insert_date, loan_num, loa
    +n_id, date_paid, payment_num, escrow, principal, interest, service_fe
    +e, net_interest, deposit_remit, balance, late_chg, other_trust, pi_co
    +nstant, ann_ir, sf_rate, due_date) VALUES (?, GETDATE(), ?, ?, ?, ?, 
    +?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)