DSXchange

Hi all,

We are trying to do a direct load from a DataSet to Oracle. When we have record on the DataSet the job finish ok, but we are facing below error when the DataSet generated from previous job doesn't have any record.

SQL*Loader-500: Unable to open file (\.\pipe\ora.64020.600000.fifo.0)SQL*Loader-554: error opening file
SQL*Loader-509: System error: The operation completed successfully.
SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.
The call to sqlldr failed; the return code = 256;

Could you, please, help us with this?

Thanks in advance.

Hi,

How about using row generator and generate a dummy record. Load the dummy record along with the dataset records. If the dataset is empty then the dummy record will get inserted.

Use close command to delete the dummy record once the load operation is complete.

HTH
--Rich

Hi Richdhan,

Thanks for the reply. We have thought the same solution you provide.

As this error seems to be an IBM bug. What we want to know is:

There is anyone who have faced the same problem?
There is an IBM patch to solve this?

Thanks.

Why not check to ensure there's data to load before invoking this process? It doesn't seem like a "bug" per se to me, the stage utilizes a named pipe to feed sqlldr and one of the two of them doesn't like the fact that there's no data to process.

Hi,

I have found a on this topic a posible solution of the bug... viewtopic.php?t=119030&highlight=Job+Ab ... e+of+nodes

Interesting... let us know after you get the patch if that fixes it for you.

Sure chulett.

I will keep the forum updated