Archives of the TeradataForum

Message Posted: Thu, 09 Dec 2004 @ 17:28:21 GMT

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

Mike,

Below is the actual SQL and the (error) messages from both SQL-A and BTEQ.

Thanks

Sankar

In SQL Assistant:

     create table dev.ct1 (n1 integer, n2 integer)
              primary index (n1) index (n1);

     Completed. 0 rows processed
     Output directed to Answer set window

In BTEQ

     BTEQ -- Enter your DBC/SQL request or BTEQ command:
     create table dev.ct1 (n1 integer, n2 integer)
              primary index (n1) index (n1);

     create table dev.ct1 (n1 integer, n2 integer)
              primary index (n1) index (n1)
     ;
      *** Failure 3519 Two indexes with the same columns.
                     Statement# 1, Info =0
      *** Total elapsed time was 1 second.

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