Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 19 Jun 2013 @ 13:06:04 GMT

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

Subj:   Re: TPT Without Schema defination
From:   Geoffrey Rommel

  Note: I don't want to define schema just want to pass databasename and tablename as argument.  

I don't know if there is any way to avoid defining the schema in TPT. On the Export, a schema is probably required, since there is no other way for TPT to know what columns are being selected in your Select statement.

Two options come to mind: (1) Write a program (Perl, Python, or similar) to read the tables and generate the TPT scripts on the fly. The program would generate the schemata. On the Load side, it could use the WildcardInsert parameter. (2) Use arcmain to ARCHIVE the table, send the output to a named pipe, and COPY the table on the other side. No schema required.

  <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: 24 Jul 2020