Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 04 Jan 2007 @ 09:58:21 GMT

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

Subj:   Re: Partition Table PPI automation
From:   Michael Larkins


I think I would experiment with either MultiLoad, TPump or FastExport because they all have the Support Environment. In it you can do all types of SQL including DDL. It also has the ability to .ACCEPT parameters from a single record flat file. These could include not only the start and end dates, but also the table and database names.

Using this technique, you would not do a .BEGIN and therefore never really run the actual utility.

Just a thought.

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

  <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