Archives of the TeradataForum

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

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

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>>