SQL loader error

199542 · Post by **199542** » Thu Mar 06, 2008 5:53 am

Hi Everybody ,
I am getting following error .....I am loading a database table through datastage ....structure of my job is as below seq -->> transformer ---> oracle database ....When my sequential file is of 0 KB its giving following error SQL*Loader-500: Unable to open file (\\.\pipe\ora.6440.788000.fifo.0)

But when my sequential file is having some data in it , Its not showing

any error . Is it a problem of sql loader or datastage ? I request you people in resolving this problem .

Thank you

199542 · Post by **199542** » Thu Mar 06, 2008 6:02 am

Previously I mentioned its a server job by mistake ...Actually its a parallel job ..

ray.wurlod · Post by **ray.wurlod** » Thu Mar 06, 2008 6:20 am

Not sure of the cause. Obviously having zero rows of source data is the culprit - and a good workaround would be to check for this situation before starting the job - but why this happens is not clear. A DataStage job can manage a "zero rows" scenario in most cases, why not this one?

199542 · Post by **199542** » Thu Mar 06, 2008 9:13 am

Hi Ray , Thanks for your reply .I am not getting that error when i am using
the either DRS stage or oracle enterprise stage with UPSERT mode .

Can anybody explain which is better oracle stage with upsert mode or

DRS stage regarding the performance wise ?

ray.wurlod · Post by **ray.wurlod** » Thu Mar 06, 2008 3:55 pm

Define "performance" in an ETL context.

Not failing would be a good start point.