URGENT! Working with SQLLE. Can't convert character string '-100' to negative for SQL output.
Posted on 2004-11-15
Please keep in mind I'm working on V5R1M0.
I'm working with a comma delimited file.
I need to be able to extract numbers and currency that may contain negatives. ('-100')
for example: A field may contain -1257.35 or -3456 between commas.
I need a routine to take any combination (-1257.35 or -3456) and change it to -125735 or -34560 in a field to do an SQL update to field defined in an SQL fetch.
The problem is I can create a negative numeric field, but when the field is moved to a character field
to perform the SQL update, I lose the negative information. Help!
This solution is needed urgently.
Please query me if necessary for more detail if necessary.
I believe daveslater created the original routine back in june using embedded SQL.