Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 14 Sep 2005 @ 09:44:15 GMT


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


Subj:   Re: Operating system of Remote Login Teradata Database
 
From:   Victor Sokovin

  Could you please let us know where is the PLATFROM colum in DBC.TVM table.  


Another good question! As a column it has been added in V2R6 only. On lower releases the platform related information is supposed to be stored, together with other bits and pieces, in column SPObjectCodeRows.

Obviously, this is just an ad hoc idea of where one *might* extract this "hard-to-find" information. If the site does not use stored procedures, then there will be no information on the platform there.

A similar idea for UDF has already been mentioned in an earlier posting. The probability of a site using UDF might still be lower than for stored procedures.


Regards,

Victor



     
  <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