Archives of the TeradataForum

Message Posted: Mon, 18 Apr 2011 @ 14:42:40 GMT

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

it works perfect to me.

     SHOW TABLE TEMP;

sql assistant output ---->

     CREATE SET VOLATILE TABLE SXXXXX.temp ,NO FALLBACK ,
          CHECKSUM = DEFAULT,
          LOG
          (
           Number CHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
           Name CHAR(25) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
           LType CHAR(4) CHARACTER SET LATIN NOT CASESPECIFIC,
           Calls INTEGER FORMAT 'ZZZ9',
           Take CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC)
     UNIQUE PRIMARY INDEX ( Number )
     ON COMMIT PRESERVE ROWS;

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