Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 17 Aug 2015 @ 19:41:17 GMT


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


Subj:   Re: TPT Load operator - Lock Release
 
From:   Pluebell, Fred

Run TPT LOAD as a "Standalone Operator", i.e. specify the same LOAD operator parameters as in the failed job but the APPLY will have no SELECT or INSERT, it just specifies the LOAD operator.

     DEFINE JOB LOAD_USER_DATA
     (
     DEFINE OPERATOR LOAD_OPERATOR
     TYPE LOAD
     (
     .
     .
     .
     );
     .
     .
     .
     APPLY
     TO OPERATOR (LOAD_OPERATOR[1]);
     );


     
  <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: 15 Jun 2023