DSXchange

I am facing a bit strange problem. I have a sequetial file stage that reads from a source. I have the Reject Mode option set to Output in the properties.
One of the columns I am trying to read in is a Integer. And, when I have data for instance as 10.45 (which is a decimal) I want to be able to reject it and capture it in the reject file rather than processing.

Here is the issue I am facing. When I run the row with above value for an integer DataStage is taking the row and ignoring the numbers after the decimal and inserting "10". I would like to reject the row and capture it in the rejects.

I tried couple of other things. I gave value "abc123" in the integer place its rejecting it successfully. At the same time, If I give it "123abc" it is not rejecting but process just the "123".

I thought its a little strange behaviour.

Have any one of you faced this kind of problem before??

I appreciate your help in this regard.

Thanks.

What are the properties involved here, particularly the Field Delimiter property?

*Topic relocated - Content Editor*

ray.wurlod wrote:What are the properties involved here, particularly the Field Delimiter property?

The field delimiter is pipe character

Nagin wrote:

ray.wurlod wrote:What are the properties involved here, particularly the Field Delimiter property?

The field delimiter is pipe character

Are there any other options or properties I am missing to specify?