DSXchange

hi,

I am using DataStage version 7.5.1 on Unix server.

We are merging two files, 6MB each. However after loading some 300 records the merge stage fails and the job aborts with the information :

1. Invalid row termination character configuration.
2. Function 'input_str_to_row' failed.
3. Function 'hashToRow' failed.
4. Function 'get_next_output_row' failed - Fatal error

Can someone please suggest, what do these error messages mean and how do we see to it that the merge stage works properly?

Thanks in advance.

rishabh wrote:...1. Invalid row termination character configuration...

have you checked your source data for an invalid/inappropriate termination character?

Does either of your sources contain newline characters in the data? If so, have you adjusted the table definition to indicate that this is the case?

it is usually because your sequtial file format is not right. I have met this error several times. suggest you to view the data to make sure either of file format is correct.