Archives of the TeradataForum

Message Posted: Mon, 19 Jul 2004 @ 19:16:44 GMT

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

Hi Fred,

We have done a work-around for this 'DUAL'. We created a DUMMY table with one row and inserted a value

     CREATE MULTISET TABLE DUMMY ,NO FALLBACK ,
          NO BEFORE JOURNAL,
          NO AFTER JOURNAL
          (
           DUMMY VARCHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC)
     PRIMARY INDEX ( DUMMY );

This should solve your puropse.

Secondly just dont mention any FROM clause.

Thanks

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