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

[Jay Vaughn <jeffersonvaughn@xxxxxxxxx>]

ok thanks chris so are you going to share  UTL_FMTNUMFORDEC?

 jay

On Fri, Feb 28, 2020 at 3:19 PM Hiebert, Chris <chris.hiebert@xxxxxxxxxxxxxx>
wrote:

> The function allows dynamic precision and scale. They are Inputs.
>
>
> DCL-S FLD2 VARCHAR(128);
> DCL-S fld1 CHAR(7);
> Dcl-s x Int(5);
> Dcl-s Y Int(5);
>
>
> You pass your string.
>
> fld1 = '002632J';
> x = 7;
> y = 2;
>
> FLD2 = UTL_FMTNUMFORDEC(fld1: x: y :*ON:*OFF);
>
> And you get this out as a String:  "26.32-"
>
>
> Chris Hiebert
> Senior Programmer/Analyst
> Disclaimer: Any views or opinions presented are solely those of the author
> and do not necessarily represent those of the company.
>
>
> -----Original Message-----
> From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Jay
> Vaughn
> Sent: Friday, February 28, 2020 11:51 AM
> To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
> Subject: Re: parse a negative number out of a before image string
>
> thanks chris but data precision and scale must be dynamically coded
>
> jay
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com