Search found 2 matches
- Fri Mar 02, 2007 4:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Identifying alphabets in a numeric field
- Replies: 5
- Views: 2461
I tried using the Alnum function.Since it checks if the argument contains alphanumeric values, even a value of '1' is getting rejected. And when Nulls are encounted,I am getting the following error: APT_CombinedOperatorController,1: Requirements Failure: Null string argument. Requirements Failure: N...
- Fri Mar 02, 2007 3:37 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Identifying alphabets in a numeric field
- Replies: 5
- Views: 2461
Identifying alphabets in a numeric field
I am reading a sequential file with varchars(all fields as varchars inculding numbers) and trying to insert them into a table.The job abended with an "Invalid Number" error.One of the numeric fields contains alphabets or some wierd characters.How can I check in the transformer stage (or any other st...