Archives of the TeradataForum
Message Posted: Wed, 19 Jun 2013 @ 13:06:04 GMT
| 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.