Hi all
i have a scenario where i need to check for value which is comming from the source that is if the value is number like 23410 the value must be entered into to the target or if any bad number like 23456# comes from the source then it must be rejected and send into the error master table
Is this type of checking possible in datastage
Can any one help me in coding for this kind of situation
Luciana, I think that ds_developer's point is that strings with a "-" and "." (or a ',' if the NLS locale is enabled) will be returned as legal numeric, so you don't need to use an additional function to remove them.