SQL loader error
Posted: 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
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