Merge stage problem

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
manavkumarm
Participant
Posts: 11
Joined: Fri Sep 05, 2003 3:45 am
Location: India

Merge stage problem

Post by manavkumarm »

Hi all,

I am using a Merge stage to merge two files using a 'Pure Inner Join' merge method. The two files are fixed-width column format files with Unix-style line termination. When I run the job, I get the following error:

Function 'construct_hash_table' failed
[Input file : MergeInput2.txt] End of row termination characters expected.

Can anyone throw any light on what the above error means?

The error seems to be linked to the row-termination characters in the input files. How I can make sure I have the right characters terminating the rows in an input file?

Thanks,
Manav
WoMaWil
Participant
Posts: 482
Joined: Thu Mar 13, 2003 7:17 am
Location: Amsterdam

Post by WoMaWil »

Before you start a merge, do a simple read with a seq-Stage, if that works continue with merge.

Wolfgang Huerter
=====================
Cologne, Germany
Post Reply