All Forums Teradata Applications
Ismailask 1 post Joined 11/15
04 May 2016
Creating a generic TPT script without specifying columns

Hi All,
 
Is there any method in TPT to build the script without defining the schema of the tables so that I can build one generic script and pass the tablename and databasename as parameter .
 
I'm trying this:
 
DEFINE SCHEMA Tables_SCHEMA @SourceTableName;
OR

DEFINE SCHEMA Tables_SCHEMA DELIMITED FROM TABLE @SourceTableName;
 
Sample job variable file

SourceTableName= 'MySourceTable'
 
Is this correct ?

You must sign in to leave a comment.