Hi all,

I am extracting data into a flat file <file01> from Oracle tables through
SQL.
The amount field in this flat file comes out as " 00000000284" for positive
amounts and "-00000000284" for negative amounts, where the last 2 digits are
decimal places for the amount value.

In Suprtool, I read this field, define and itemize it as follows :

IN <file01>
DEF AMOUNT,1,12,DISPLAY
ITEM AMOUNT,DECIMAL,2
EXT AMOUNT
OUT file02,link
XEQ

Everything works out fine.. When I try to do total on this amount field or
try to add this amount field to another field, it blows with the error
message as "Error:  Illegal ascii digit in the input record". I can see that
there is a space instead of '+' sign. Is there any way in Suprtool that I
can define or itemize and then extract this variable including the signs so
that my totals or adds later on does not fail ?

Any help is greatly appreciated.. !! Eeeeeeks. I dont want to touch Cobol
here... !!

With Best Regards
Raghu. Rao
Email: [log in to unmask]

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *