Archives of the TeradataForum

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

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

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