Archives of the TeradataForum

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

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

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