Archives of the TeradataForum

Message Posted: Thu, 03 Jul 2003 @ 08:22:09 GMT

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

<-- Anonymously Posted: Wednesday, July 02, 2003 20:41 -->

When creating the table, I have these fields and other one and table is created successfully.

CREATE:

      END_DATE TIMESTAMP(0) NOT NULL,
      START_DATE TIMESTAMP(0) NOT NULL,

In the define stage, it is defined as follow and got "Definition syntax error"

DEFINE:
         ,END_DATE (TIMESTAMP(0))
             ,START_DATE (TIMESTAMP(0))

Have any one experience this or have any pointers?

--------------------------------------------

**** 17:26:31 FDL4822 DEFINE statement rejected.
**** 17:26:31 Definition syntax error for: END_DATE

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