Does sql support substr on an numeric?
You could write a UDF to read this column
select columna, columnb,myRpgUdfToConvertThisToNumeric(columnc)...
Hopefully that won't process it before it passes it out to the UDF.
If you are using this in a cursor in RPG or cobol and your fetch aborts
due to this error you could just iterate your fetch loop.
If you are writing this in SPL perhaps some judicious use of WHENEVER is
If you can overlay the numeric with a character by the use of a view
perhaps you clean it up with a common table expression first.
Not that you want to hear this but I just have to pipe in that if you
created this file with SQL's DDL instead of DDS you wouldn't be having