Archives of the TeradataForum

Message Posted: Wed, 08 Oct 2002 @ 23:39:01 GMT

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

The error is probably caused because the mload utility performs a seek on the input file. For ordinary files, this is no problem but pipes (both anonymous and named) do not support this operation.

I am assuming you are running on Unix, because on Unix, system error 29 is an "illegal seek".

We use named pipes and encountered this error many many many years ago. If memory serves, setting checkpointing (on the .begin import statement) to the highest possible value seems to work. Here are some things you might try:

* Set checkpointing to the largest possible value (we initially used 20000000)

* Run the multiload twice (once for each input file)

* write an inmod to read either the named pipe or the input files (this prevents mload from performing the seek on the input file).

For our application, setting the checkpointing seems to work. We did not need to run multiple mloads or write an inmod.

Hope this helps.

Glenn Mc

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