Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 20 Mar 2006 @ 09:30:56 GMT


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


Subj:   Re: Capturing Activity Count insite bteqs
 
From:   Anomy Anom

<-- Anonymously Posted: Sunday, March 19, 2006 23:38 -->

I think one can capture ACTIVITYCOUNT in the shell and then try to insert into the (audit-statistics) table.

I guess this can go on the following lines..Im not on teradata now and have no method to verify this..

     bteq <<-!

     .logon


     SELECT stmt;

     .OS ACTIVITY_COUNT_VARIABLE = ACTIVITYCOUNT
     .
     .
     .

Regards



     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023