Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 16 Mar 2001 @ 09:24:28 GMT

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

Subj:   Re: Number of request by user
From:   David Wellman


Do you have a specific reason for using AccessLog?

Assuming that you don't and that all you want is the number of requests issued by a user, you could try using Account String Expansion (ASE). One of the variables available is (I think) &I which will give you one row per amp per request from each user. To achieve a simple count of requests then becomes a count of rows in dbc.ampusage divided by the number of amps. Like access logging, using this feature will add to the number of rows in dbc.ampusage and you will need to housekeep the table.



  <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