Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 10 Jun 2004 @ 08:58:31 GMT


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


Subj:   Re: How do I CAST a numeric into a numeric?
 
From:   Pandey, Vivek

Hi Bob,

1. Your subject line doesn't match your problem in the mail text.

2. I hope your column definition for server_num is dec(6,0).

3. If above is correct then what you get in the output is correct.

4. If you want to remove the period from your output then use the below sql(which uses implicit conversion).

     BTEQ -- Enter your DBC/SQL request or BTEQ command:
     show table t1;

     show table t1;

      *** Text of DDL statement returned.
      *** Total elapsed time was 1 second.

     ------------------------------------------------------------------------
     CREATE SET TABLE VIV.t1 ,NO FALLBACK ,
          NO BEFORE JOURNAL,
          NO AFTER JOURNAL
          (
           a DECIMAL(6,0))
     PRIMARY INDEX ( a );


      BTEQ -- Enter your DBC/SQL request or BTEQ command:
     SEL a (CHAR(6)) FROM T1;

     SEL a (CHAR(6)) FROM T1;

      *** Query completed. 2 rows found. One column returned.
      *** Total elapsed time was 1 second.

     a
     ------
         12
      12345

      BTEQ -- Enter your DBC/SQL request or BTEQ command:

Thanks, Vivek.



     
  <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