Archives of the TeradataForum

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

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

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>>