Error at Standardize Stage in QualityStage

Infosphere's Quality Product

Moderators: chulett, rschirm

Post Reply
mdvprasad
Participant
Posts: 1
Joined: Wed Sep 10, 2008 7:17 pm

Error at Standardize Stage in QualityStage

Post by mdvprasad »

I am using a .csv file as input for the Standardize stage.
When I run a job using the Standardize rule sets, I receive an error at the Standardize stage saying "Standardize_1,1:non-negative numeric operand is expected". I have all the inpur columns as varchar and name is divided into three columns, First, Middle, and Last Names.

Any ideas???[/quote]
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Welcome aboard.

What rule set are you using for your Standardize stage?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Vkharia
Participant
Posts: 9
Joined: Thu Sep 04, 2008 4:56 am

Post by Vkharia »

Hi,

Even I am facing the same error in one of the Standardise jobs. I am using "USPREP.SET" with ZQAREAZQ & ZQADDRZQ as the literals.
Kindly suggest.
reachsam11
Participant
Posts: 26
Joined: Wed Mar 17, 2010 11:05 am

Post by reachsam11 »

I am using USPREP rule set with literal ZQMIZNZQ and i get the error 'Non-negative numeric operand expected' on the standardize stage.

Did anyone find the solution?
ReachSam
Post Reply