Archives of the TeradataForum

Message Posted: Thu, 29 Sep 2005 @ 14:12:43 GMT

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

I'm trying to use Tpump to continually load data that it reads from a named pipe. The problem I have is that Tpump ends when the data stream stops writing to the pipe.

MY test example starts Tpump reading from the named pipe, which then blocks as there's nothing writing to it immediately, then I start a UNIX script that echoes some data to the pipe every second. Once the first echo finishes, Tpump loads the data and then closes. If I try to send data into the pipe without a pause then anywhere between 50 and 300 (or so) records will be loaded before Tpump closes. I don't know why this isn't constant but there you go.

What I want is for Tpump to run effectively forever and just load data when something writes to the pipe. Looking at the named pipe stuff in UNIX it looks like I need to get Tpump to open the named pipe read/write so it doesn't block and rely on something writing to the pipe, but I'm not sure if that's the whole solution. I'm also not sure how (or if) Tpump can tell the named pipe access module how to open the pipe.

So my question is essentially, is it possible to have Tpump sit there and load data when something writes to it, and how does one achieve this. I've seen references in the manuals to trickle feeding Tpump, but no info on how to actually do it.

Thanks in advance,

Jim Hudd.

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