I am trying to run a sql loader .ctl file from a .bat file.
The data file (.txt), the .ctl file are both in the same directory. The .ctl starts but then I get a .log file that reads the following error message:
SQL*Loader-500: Unable to open file (c:\narrative.txt)
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
If I put a path for the .txt, then the loader will run.
I was able to do this in other .bat files without specifying a path for the .txt so I would like to know why after reinstalling sqlldr73 and sqlldr80 on my machine, I now have to path the .txt.
Thanks
goldenhead
The data file (.txt), the .ctl file are both in the same directory. The .ctl starts but then I get a .log file that reads the following error message:
SQL*Loader-500: Unable to open file (c:\narrative.txt)
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
If I put a path for the .txt, then the loader will run.
I was able to do this in other .bat files without specifying a path for the .txt so I would like to know why after reinstalling sqlldr73 and sqlldr80 on my machine, I now have to path the .txt.
Thanks
goldenhead