Problem with appending the seq file

[raj158347]

Hi all,
In a job, I have one seq file as input and 2 links in the output both links are pointing the same seq file,
I am try to update the file with two links at same time but it is taking only one link data but in the same time if i see the director it shows same amount of the data in the both output links.

FYI
I have marked the seq file as appending with exiting rows.
I am using 7.1 version.


i/p file ------> |TRN | -------> link1
| | O/P File
| |-------->link 2


e.g) input has 3 files trnsformer doesn't have any codition just updating the o/p file with 2 links
I am expecting 6 files in the o/p file but am getting only three from the second link

This is testing job only ..The actual purpose. i want to append the seq file with different instance in parallal

Can any please provide solution for this with out creating different files and then merge.


Thanks &Regards
Rajkumar

[sachin1]

Please have a look on the input tag of sequential file stage, and check for input name should be different, i think in your case input name is same.

[raj158347]

Thanks for reply actualy i want to update the same file .
Is not possible?

[ArndW]

You cannot have 2 links writing to the same sequential file. Make both links go to a link collector and then have one link append to your sequential file.

[chulett]

Well, technically you can as long as one is set to 'append' - and it only runs after the other finishes. It's the old 'same file at the same time' problem, no can do. And for the record, that's a sequential file 'restriction' not anything posed by DataStage.

[ArndW]

Ok, I should have stipulated "you cannot have 2 links writing to the same sequential file in the manner you have shown"

[chulett]

[raj158347]

thanks for your kind reply ..

now i am planning to use different seq file and then merge


Thanks & Regards
Raj