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]
Unable to open file
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
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.
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.
Anything that won't sell, I don't want to invent. Its sale is proof of utility, and utility is success.
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
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
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
I dont think so . Try three transformers in one job.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
In your case may be the problem in free disc space or seq file path (I have confused with path several times)