Merge stage in server edition

jusami25 · Post by **jusami25** » Thu Mar 02, 2006 5:03 am

Hi guys,

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.

Thanks in advance
Julio

ArndW · Post by **ArndW** » Thu Mar 02, 2006 5:18 am

Julio,

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.

kris007 · Post by **kris007** » Thu Mar 02, 2006 7:09 am

Julio,

Fill in the temporary directory on the General tab of the Merge stage and that should take care of the error. Let me know if it worked.

Kris.

jusami25 · Post by **jusami25** » Thu Mar 02, 2006 7:58 am

Hi Kris,

actually adding the temp directory seems to work fine. Now I'm having a different error:

MergeTest..Sequential_File_3.IDENT1: Function 'get_next_output_row' failed
Data length (1 bytes) is greater than column length (0 bytes).

But i think this is due to column size problems.

Thanks
Julio

kris007 · Post by **kris007** » Thu Mar 02, 2006 8:20 am

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.

Kris.

jusami25 · Post by **jusami25** » Thu Mar 02, 2006 8:44 am

Hi Kris,

it was the scale property of the column definition, once it's set correctly everything is fine.

Good point about the temp directory, that was causing the weird error.

Many thanks
Julio

kris007 · Post by **kris007** » Thu Mar 02, 2006 8:55 am

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....

Kris