Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 20 May 2003 @ 18:31:20 GMT


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


Subj:   DataType from Dictionary Tables
 
From:   Ganga Palakattil

When I read the dictionary table (DBC.COLUMNS) for data-type, I am getting only the abbreviated value for the ColumnType. Therefore, I need to use the CASE statement for every possible data-type abbreviation to print the table structure from the dictionary.

Is there any table available in the dictionary that gives the full expansion for the ColumnType?


Thanks in advance...

Ganga Palakattil



     
  <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