Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 17 Oct 2013 @ 22:17:22 GMT


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


Subj:   PPI Revaildation
 
From:   Singh, Ravi Pratap

Hi Folks,

I was looking for a way to identify tables whose PPI range is ending in 2013.? I know we could use DBC.IndexConstraints to get the PPI text. But parsing that text manually seems to be a herculean task specially when there are tons of tables sitting in system. I did try to chop PPI text down using substrings and cases but nothing seems to work perfectly.

Did anyone tried that before? Any insight will be helpful..!!


Regards,

Ravi



     
  <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