Archives of the TeradataForum

Message Posted: Fri, 17 Mar 2006 @ 22:44:29 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Friday, March 17, 2006 16:56 -->

Not sure if this is the best way, but I've been using perl/sed to parse BTEQ output for status on records insert/updated (After cron job, etl scheduled... etc.)

Might look something like this:

     open(FILE,"./file_name.log") ;
     while(){
           if (/^ \*\*\* Insert completed\. (\d+) rows added\. $/){
                 $inserts = $1;
                 print "$inserts inserted\n";
           }

           #Find update Row
           if (/^ \*\*\* Update completed\. (\d+) rows changed\. $/){
                 $updates = $1;
                 print "$updates updated\n";
           }
     }

	<Prev	Next>		<<First	<Prev	Next>	Last>>