Validation Rule set

BuddingDev · Post by **BuddingDev** » Wed Feb 15, 2012 4:33 pm

I don't see validation rule set such as VEmail and VPhone under Standardization Rules in my designer.

I have an access for 8.1 and 8.5 Datastage version but validation rules are no where to be found.
Could somebody provide me any kind of hints to locate them?

Any kind of inputs are much appreciated.

rjdickson · Post by **rjdickson** » Wed Feb 15, 2012 4:35 pm

Hi,

You can open the 'Advanced Find' and look for VEMAIL*, or you can look under ./Standardization Rules/Other.

BuddingDev · Post by **BuddingDev** » Wed Feb 15, 2012 4:45 pm

Yes, I found them under Standardization Rules/Others.

Thanks for your quick reply.

BuddingDev · Post by **BuddingDev** » Wed Feb 15, 2012 4:45 pm

Yes, I found them under Standardization Rules/Others.

Thanks for your quick reply.

ray.wurlod · Post by **ray.wurlod** » Wed Feb 15, 2012 5:25 pm

Beware that the validation rule sets (VEMAIL, VPHONE, etc.) are highly US-centric.

For example VEMAIL can not cope with zaphod@h2g2.co.uk (the rule set requires a "com" domain, not a "co" domain).

rjdickson · Post by **rjdickson** » Wed Feb 15, 2012 5:33 pm

Hi Ray,

Fair point, however your specific example does work. .CO is actually recognized now (but may not have been at one time in the past)...

ray.wurlod · Post by **ray.wurlod** » Wed Feb 15, 2012 5:45 pm

Good. I suspect the VPHONE and know that VTAXID don't work where I am.

rjdickson · Post by **rjdickson** » Wed Feb 15, 2012 6:02 pm

Hi Ray,

Yes, you are correct!

Robert

qt_ky · Post by **qt_ky** » Sun Feb 19, 2012 7:46 pm

VTAXID isn't good for much anywhere... It mainly just checks that not all digits are equal.