Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 18 Mar 2004 @ 17:32:25 GMT


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


Subj:   Persistence of TPUMP fed by a pipe
 
From:   Arnaud_Balat

Hi,

My goal is to load data continuously using tpump.

I have a pipe on my server (on Linux using mknod) and the tpump script imports from that pipe using .IMPORT like below:

        .IMPORT INFILE ${PATH_TO_INPUT}/input_pipe
                FORMAT VARTEXT '|'
                LAYOUT MYDML
                APPLY UPSERT_ALL;

Once the tpump empties the pipe it will run .END LOAD and .LOGOFF.

I would like the TPUMP to be persistent - wait or loop - even if the pipe is temporarily empty but I don't seem to manage it and couldn't find hints in the doc either.

The main reason would be to not have to connect - disconnect - reconnect all day long 24/7.


Thanks for your advices.

Arnaud



     
  <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