I trying to use the merge stage in a server job. First thing is I cannot drag input links to the merge stage. I guess it's because this stage doesn't need any link cause you specify directly within the stage the path and file you want to merge, but even without setting any input link the job aborts.
DataStage Job 203 Phantom 4548
Program "DSP.Open": Line 122, Exception raised in GCI subroutine:
Access violation.
Attempting to Cleanup after ABORT raised in stage MergeTest..Merge_0
DataStage Phantom Aborting with @ABORT.CODE = 3
I have no clear picture about using the merge stage in server jobs.
try to start off with a very simple example to get a feel for how the stage works. Create two sequential files with just a couple of lines and only two columns and use that as the basis - once you have that working you can start making the join more complex and can work with "real" data.
Yeah..It might be column size problems. I remember reading somewhere in this forum that one need to be careful while dealing with the datatypes in the Merge stage. I tried to do a quick search but looks like i missed it. Search the forum with key words 'Merge stage'. I'm sure you will find it in there. Let me know if you can't find it.
Not a problem. Just use the search facility effectively on this forum. I find it very helpful. Most of the topics have already been discussed here. So there's no need to panic at all....