Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

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


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.


  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020