DSXchange

Does anybody have any hints regarding how to reject rows in a transformer when they have NLS Errors?

My Job Looks like : XML Input file --> Transformer --> Hash File

What I want to do is to check NLS compatibility in every row I read in the transformer and reject the ones not compatible or the ones that produce warnings in the Job log. So at the end I can check and have a Report which rows are having Problems

Thanks a lot in advance

Rgds
Max

Invoke a routine that applies an Oconv() function specifying the NLS map, and check the value of Status(). It will be 0 if the NLS mapping was successful, or a non-zero value otherwise. Use that result to determine whether to reject the row or not.

Thanks a lot for your reply, Ray. But unfortunately, I'm still not a premium member and I cannot see the full message.

Would it be possible for you to reply ot my message in any other way, or tu send the reply to my email.

Thanks a lot in advance
Rgds
Max

The pith of my response was already visible, so I've exposed the remainder.

Thanks a lot Ray!. I have done as you suggested and worked perfect.

Thanks a lot for you help

Rgds
Max