Ruleset

nilanjan · Post by **nilanjan** » Thu Mar 14, 2013 1:38 am

Which stage is better to generate country code.MNS or country.set ruleset.I need three byte country code.

ray.wurlod · Post by **ray.wurlod** » Thu Mar 14, 2013 1:55 am

If that's all you need, then COUNTRY.SET is more efficient. However, it only generates the two-character ISO country code; you would need to map to the three-character code downstream of the Standardize stage.

stuartjvnorton · Post by **stuartjvnorton** » Thu Mar 14, 2013 2:44 am

As Ray said, the Country typeset would be a better place.

Another way to do it Is to make a copy of the set, add a new field in the DCT file, create a lookup table mapping the 2 char codes to the 3 char ones, and do a convert in the PAT file. Then the ruleset can return both codes.

nilanjan · Post by **nilanjan** » Fri Mar 15, 2013 1:00 am

The problem i am facing while using Country.set is ,suppose i have a wrong address,the addressline 1 has streetname of US,the city name is hongkong and country is China.It will not be able to determine any country code.As, i m setting the default value as USA,by using ZQUSZQ it retruns the country code US.How can i resolve this?

ray.wurlod · Post by **ray.wurlod** » Fri Mar 15, 2013 3:10 am

Try leaving out the street name; resolve just the city, postal code and state/province/county.