Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 23 May 2006 @ 09:35:23 GMT


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


Subj:   Error - 3789: multiple Format opions
 
From:   Saurabh_Dinesh

Hi,

I am facing problem while creating a table i.e. it gives the Error-

3789: Multiple Format options.


The DDL statement goes like this

CREATE SET TABLE abc ,NO FALLBACK ,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL
     (
      Prod_Id INTEGER TITLE 'Product Identifier' NOT NULL,
      Prod_Grp_Id INTEGER TITLE 'Product Group Identifier' NOT NULL,
      Prod_Grp_Tp_Cd CHAR(6) NOT NULL,
      Prod_Grp_Assoc_Eff_Dt DATE FORMAT 'YYYY-MM-DD' TITLE 'Product
Group Association Effective Date' NOT NULL,
      Prod_Grp_Assoc_Eff_Tm TIME(0) FORMAT 'hh:mi:ss' TITLE 'Product
Group Association Effective Time' NOT NULL,
      Prod_Grp_Assoc_End_Dt DATE FORMAT 'YYYY-MM-DD' TITLE 'Product
Group Association End Date',
      Prod_Grp_Assoc_End_Tm TIME(0) FORMAT 'hh:mi:ss' TITLE 'Product
Group Association End Time',
      Batch_No INTEGER TITLE 'Batch Number' NOT NULL)
PRIMARY INDEX ( Prod_Id );

The above query is working on one server but the same query gives error on another server.

Is there a way out of the problem?


Regards,

Saurabh



     
  <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: 15 Jun 2023