DSXchange

Posted: **Tue Nov 21, 2006 6:27 am**

Hi Friends,

I am in trouble again!
In my job, I am appending the incoming data to a same target seq file.
The Seq File Stage has 1 input streams which is appending the data to the same seq file. This seq file satge is a part of the shared container and my job uses 3 instances of that shared container. These are the sahred containers: GLJrnlLineP3I3AAC40, GLJrnlLineP3I3AAC38
This is the log:

Code: Select all

J_PP_GL_JRNL_LN_Part2_AA..[b]GLJrnlLineP3I3AAC40[/b].Xfmr_Insert_Logic: |J_PP_GL_JRNL_LN_Part2_AA..GLJrnlLineP3I3AAC40.Open_Open_GL.Link_To_Open_Item_Table: DSD.SEQOpen Unable to create file Open_Item_GL_AA.dat.|

J_PP_GL_JRNL_LN_Part2_AA..[b]GLJrnlLineP3I3AAC38[/b].Open_Open_GL.Link_To_Open_Item_Table: DSD.SEQOpen Unable to create file Open_Item_GL_AA.dat.

J_PP_GL_JRNL_LN_Part2_AA..[b]GLJrnlLineP3I3AAC38[/b].Xfmr_Insert_Logic: |J_PP_GL_JRNL_LN_Part2_AA..GLJrnlLineP3I3AAC38.Open_Open_GL.Link_To_Open_Item_Table: DSD.SEQOpen Unable to create file Open_Item_GL_AA.dat.|

Thx

Posted: **Tue Nov 21, 2006 7:06 am**

That's because you're breaking the rules again. The operating system (not DataStage) only allows one writer to a file at one time. You must write to separate files, and assemble them into one afterwards with a TYPE command.

Posted: **Tue Nov 21, 2006 8:48 am**

Data is written in blocks of characters (4K, 8K, etc). There is no concept of a "row" in a file, therefore, simultaneous writers will interleave data in the file according to the block size. Also, you'll have to deal with locking mechanisms the operating system may impose.

DSXchange

Appending to same SeqFile from multiple input links

Appending to same SeqFile from multiple input links