Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 28 Sep 2011 @ 08:18:02 GMT


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


Subj:   How to Fetch tables from Database with different suffixes
 
From:   Bodla, Sravan Kumar

Dear All,

In our Environment, we take the backup of the tables in the database suffixing the date.

Like,

     T_Abc_1_b_2809
     T_234Xyzsdf_abcdf_12_1308
     T_1_Pqrst_abc_123_cd_1408
     Ijkl_pqr_11_bcd_1206
     Pqrst_abc_123_cd_BKP
     T_1138_Ikl_pqr_11_bcd_1102
     ghisdf_aoiuf_12_TMP
     T_Ijkl_pqr_11_bcd_HIST

Can you please help me how can I fetch these kind of tables from the database?


Thanks,

Sravan.



     
  <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: 27 Dec 2016