Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Fri, 18 Oct 2013 @ 19:42:16 GMT


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


Subj:   Re: PPI Revaildation
 
From:   Singh, Ravi Pratap

Thanks Anomy,

Unfortunately it does not cover all of my cases. For example,

- When multiple "between" clauses are present in PPI constraint. Your query will show the startdate and end date for first "between" clause only.

- When dates are stored/partitioned as integer.

- When PPI constraint is too complex to break as date. For example DATE + ADD_MONTH(25) etc.


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: 24 Jul 2020