Unable to open file

[murali]

Hi iam trying to create a file sdadata.data in my job and when i try to append in the next sequentail file stage iam getting this error.


odbc------>transformer----->file1,file2 ,file3

from the transformer there are 3 files as shown above.
the file is being created,but when say append to existing file it giving the error



J_TEST_IN..DATAFILE1.PP_TREE_CATEGORY2: DSD.SEQOpen Unable to create file E:\TEMP\DATAFILE.DATA.
Can any one help me [/code]

[I_Server_Whale]

Hi Murali,

When you access the file in the 'next ' stage, Is your first seq. file stage finished with its processing.

Make sure that the file sdadata.data is not being accessed while it is being accessed in the 'next' stage.

Sequential files do not allow multiple access at a time.

Thanks,
Naveen.

[ray.wurlod]

Does the folder E:\TEMP exist? Do you (the DataStage executing user) have permission to write into it?

[I_Server_Whale]

:D Good Point by Ray. I forgot about that.

[murali]

Hi ray and naveen

Does the folder E:\TEMP exist? Do you (the DataStage executing user) have permission to write into it?
I have the permission to write into the file and the folder exists.

Is there any way i can write a constraint so that after finising the first stage file 1 (the process of first writing into the sequential file1) and then i can start the second stage process.
thankyou
murali

[snassimr]

Is there any way i can write a constraint so that after finising the first stage file 1 (the process of first writing into the sequential file1) and then i can start the second stage process.
thankyou

I dont think so . Try three transformers in one job.

In your case may be the problem in free disc space or seq file path (I have confused with path several times)