Page 1 of 1

Importing Sequential File Definitions

Posted: Wed Apr 25, 2007 5:58 pm
by boligoma
Hi, I'm having a lot of trouble trying to import some text file definitions to Datastage Manager. When I try to import any file the following message appears:

DSR.MetaGeta(GET.SEQ.SAMPLE): OPENSEQ of /projectds/Operator/files//File_Special.txt took ELSE clause, STATUS()=0

I'm connecting via VPN to another server which has those files, I'm using DS 7.5.1.A. I can see the root though but I cannot import the definition.

Any help will be appreciated,

Posted: Wed Apr 25, 2007 6:22 pm
by ray.wurlod
There is an extraneous "/" in the pathname. Getting rid of it will probably fix the problem. DataStage does not resolve "//" in pathnames.

Posted: Thu Apr 26, 2007 8:45 am
by boligoma
Thanks for the answer, I'm still getting the same message without the "/" that was before, like this:

DSR.MetaGeta(GET.SEQ.SAMPLE): OPENSEQ of /projectds/Operator/files/File_Special.txt took ELSE clause, STATUS()=0

Please advice, thanks!!!

Posted: Thu Apr 26, 2007 4:32 pm
by ray.wurlod
Taking the ELSE clause with Status() returning 0 indicates that the file is opened for writing, but does not exist. Check that /projectds/Operator/files/File_Special.txt exists, that components in the path are correctly spelled and cased, and that the executing user has sufficient rights to access these directories and the file.

Posted: Thu Apr 26, 2007 4:54 pm
by boligoma
Got it, actually somebody yesterday was updating the file. I don't know if it's related but that file was created in 1.5.2 and when trying to accesing it with 1.5.1.A it fails.

I made the test with 1.5.2 and it worked fine.

Thanks!!!