Archives of the TeradataForum

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

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

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>>