Search found 2 matches

by Lalitha
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: 2457

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...
by Lalitha
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: 2457

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...