Archives of the TeradataForum
Message Posted: Wed, 08 Oct 2002 @ 23:39:01 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|