Page 1 of 1

Unable to open sequential file

Posted: Sun Dec 04, 2011 4:42 pm
by vskr72
I am trying to load data from one CSV file to another CSV file. Its a simple job. I created the target file using the touch command so a zero byte fiel exists in the target folder. Validation is OK. When I run the job, it says the following for the target file:

Code: Select all

Target,0: Unable to open /opt/IBM/InformationServer/Projects/dev/target/test1.csv: Permission denied.
IS there anything that I am missign here.

Kumar

Posted: Sun Dec 04, 2011 4:49 pm
by ray.wurlod
You may lack write privilege for the "target" directory if "test.csv" does not exist, or to "test.csv" if it does exist.

Posted: Sun Dec 04, 2011 8:50 pm
by qt_ky
Try it without touching the new target file first. if you're running a default setup then your persoanl unix ID is probably not the same ID that the job executes under, which may be dsadm. If the touch command worked then check the file permissions. You may need to use the chmod command to correct them. Default permissions can be wrong. If so then you can add a better setting with a umask command in your .profile file.