How to Reject Rows having NLS mismatch

mgsteiner · Post by **mgsteiner** » Thu May 16, 2013 5:39 am

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

ray.wurlod · Post by **ray.wurlod** » Thu May 16, 2013 5:51 am

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.

mgsteiner · Post by **mgsteiner** » Thu May 16, 2013 6:05 am

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

ray.wurlod · Post by **ray.wurlod** » Thu May 16, 2013 1:57 pm

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

mgsteiner · Post by **mgsteiner** » Fri May 17, 2013 1:04 am

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

Thanks a lot for you help

Rgds
Max