Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 03 Aug 2006 @ 13:58:28 GMT


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


Subj:   Re: How to determine column data types for VIEWS
 
From:   Dempsey, Mike

If you are writing an app to do this (rather than SQL) you can use the ODBC function SQLColumns() to fetch this information.

If you want to use SQL then use:

     HELP COLUMN ..*

You will need to translate the values returned in the 'Type' column.

     CF - CHARACTER FIXED
     CV - CHARACTER VARYING
     I  - INTEGER
     etc.

The other columns will depend on the data type.

Use 'Max Length' for character columns.

Use 'Total Digits' and 'Fractional Digits' for Numerics.


Mike Dempsey
Teradata Client Tools



     
  <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: 23 Jun 2019