Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 27 Aug 2015 @ 20:58:39 GMT


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


Subj:   Re: DB2 to Teradata Convertion - CHAR with DEFAULT
 
From:   Dieter Noeth

Anomy.Anom wrote:

  I am converting some DB2 DDLs to Teradata equivalent. For some columns in DB2 I see the following definition -  


  MyColumn CHAR(n) FOR SBCS DATA WITH DEFAULT;  


  I searched the web and found that in such cases, for a CHAR(n) field, if only the keyword "DEFAULT" is specified (without any value specified), DB2 fills up the field with "n" number of spaces automatically.  


It's exactly the same syntax in Teradata (without "FOR SCBS DATA"):

     MyColumn CHAR(n) WITH DEFAULT

Dieter



     
  <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