Re: parse a negative number out of a before image string

"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> wrote on 10/30/2019
11:35:13 AM:

i don't have the likeRec def to overlay with... this trigger submits
another trigger to batch, passing ONLY the before/after image strings
(along with libname and filename)...
so Im literally plowing through syscolumns using columnames and

attributes

to parse out the pieces from the string.

don't ask why... it is what it is. :(

The data appears to be signed zoned decimal. So, create a
character field 9 characters long and position a zoned field over the top
of it. Then just move the data to the character field and that will
automatically translate the overpunched sign to a negative number in the
zoned field that overlays it.


Sincerely,

Dave Clark