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
Problem with appending the seq file
Moderators: chulett, rschirm, roy
Re: Problem with appending the seq file
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.
Re: Problem with appending the seq file
Thanks for reply actualy i want to update the same file .
Is not possible?
Is not possible?
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Ok, I should have stipulated "you cannot have 2 links writing to the same sequential file in the manner you have shown"
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>