Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 18 Jun 2004 @ 05:28:49 GMT

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

Subj:   Re: Target table was restructured resubmit
From:   Michael Larkins


It does not make any sense to do what you are coding. Why make it select the data into SPOOL to just write it out using the first column as a NUPI?

try the following:

     create table database_name.test_table
       as another_db.another_table  with data;

Unless you are getting rid of some of the data rows or some of the columns, there is no need to select the rows.

Hope this helps,

Michael Larkins
Certified Teradata Master

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019