Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 14 Jun 2012 @ 20:30:45 GMT


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


Subj:   Copy table across dev. and prod
 
From:   Issah, Gabriel

I have 2 tables with same create dll, the only thing different is the naming dev.tableA and Prod.tableA. Sitting on 2 separate box. I just want to copy or Insert data from dev.table to Prod.tableA.

My Insert statement did not work, I also tried

     COPY DATA TABLE (Prod.TableA)
     (FROM (Dev. TableA), NO JOURNAL, NO FALLBACK) ,FILE = ARCHIVE;

My table:

     CREATE SET TABLE Prod.TableA ,NO FALLBACK ,
          NO BEFORE JOURNAL,
          NO AFTER JOURNAL,
          CHECKSUM = DEFAULT,
          DEFAULT MERGEBLOCKRATIO
          (
           a_Id INTEGER TITLE 'Claim Service Detail Id' NOT NULL,
           beginDate TIMESTAMP(6)   NOT NULL,
           Enddate TIMESTAMP(6)  ,
            DelFl CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'S DeletedFlag',
           InvoiceId INTEGER TITLE 'Invoice ID',
           InsertDate TIMESTAMP(6) TITLE 'InsertDate' NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
           UpdateDate TIMESTAMP(6) TITLE UpdateDate DEFAULT NULL  COMPRESS )

     PRIMARY INDEX ( a_Id );

Both did not work any help


From Glob



     
  <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: 27 Dec 2016