Archives of the TeradataForum

Message Posted: Sat, 08 Dec 2012 @ 15:56:09 GMT

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

Hi James,

If you want to use any components of a SELECT statement then your CREATE TABLE AS command must use the SELECT variation. Try:

     CREATE TABLE t2
     AS
     (Select ...
     From t1
     Sample 0.1) with data

But remember that if you're doing this then you should probably specify the column(s) required for the Primary Index. This option will default to the first column being a NUPI or it might build a NOPI table depending on your release of TD and the PrimaryIndexDefault setting in DBSControl.

Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)

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