Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 05 Aug 2004 @ 11:45:24 GMT


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


Subj:   3789 - Multiple Format error
 
From:   Binoy Mathunni

Can some one help me in getting the error as "3789 - Multiple format options" while creating tables

     create multiset  table tpch.TABLE_NAME,
     no fallback,
     no before journal,
     no after journal
     (
     account_no decimal(10,0) not null,
     company_number smallint compress(1,2,3,4,5,6,7,8,9),
     .......................
     ........................
     company_number1 smallint compress(1,2,3,4,5,6,7,8,9)
     )

Note : I have more than 100 columns to create, Very intresting thing is the statement will execute fine if you remove the "company_number" column, And later i can alter the table with the addition of same column.


Thanks

Binoy m



     
  <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