Error with Mexico - PREP ruleset in QualityStage

Infosphere's Quality Product

Moderators: chulett, rschirm

Post Reply
divstands
Participant
Posts: 128
Joined: Wed Jun 03, 2009 9:48 am

Error with Mexico - PREP ruleset in QualityStage

Post by divstands »

I am getting the following error while running a job which includes the usgae of PRPE rulesets for mexico( MXPREP):



stanMXPREP,0: STANDARDIZE output column #D | $ [ {NombreDistrito} = "" ]
in rule set MXPREP is not defined in the dictionary
[stancmp4.c:2416]


Tha job looks like: Inout sequential file->Filer(Select MX as the country)
-> Standardize( Mexico CNTRY MXPREP.set)->Standardize( MXADDR.set, MXAREA.set)->Output Sequential file

Also, if the full address is like this:

Street : Domicilio Conocido
Ext No. : SN
Int. No. : 4
Colony : Santa Catarina Tabernillas
Municipality: Almoloya De Juarez
City : Almoloya De Juarez
State : Mexico
Postal Code : 50920
Reference Location: Cerca Del KM 7

then the final output files show:

DominioDirecccion_MXPREP ( Domain Address)

= SN Domicilio Conocido Almoloya De Juarez Cerca Del KM 7 <a symbol like a square> Almoloya De Juarez Mexico 1 50920

and

DominioArea_MXPREP (Domain Area)

=ZQAREA ZQAREA ZQAREA ZQAREA


In the Standardize( Mexico CNTRY MXPREP.set) stage i have put :
ZQADDRZQ Ext No ZQADDRZQ Int No ZQADDRZQ Street ZQADDRZQ Colony ZQADDRZQ Municipality ZQADDRZQ Reference Location ZQAREAZQ City ZQAREAZQ State ZQAREAZQ Postal Code

What can be the issue? Whyare all the fields being taken under address only inspite when everything has been seggregated at proper place?

Regards

DivT
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

An output column used by one of the rules in your MXPREP rule set is not actually defined in the output file's file definition.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply