Re: Converting Character Zoned Data to Numeric in SQL

["Jonathan Mason " <jonathan.mason@xxxxxxxxxxxxxxxx>]

Hi Glenn

Not sure I follow.  The data is already in character format and I need
to convert it into a numeric value that can then be summed up.  If I use
any of the existing BIFs, e.g. DEC, ZONED, etc, it gives me an error
that the field contains invalid data - which I guess is the "negative"
digit (J, K, L, etc).

Thanks

Jonathan



Glenn Gundermann <glenn.gundermann@xxxxxxxxxxxxxxxx> wrote :

> You will want to convert it to character.
>
> Glenn Gundermann
> Glenn.gundermann@xxxxxxxxxxxxxxxx
> Sent from my BlackBerry device on the Rogers Wireless Network
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.


Jonathan Mason
iSeries Consultant
www.astradyne-uk.com


_______________________________________________________
This message was sent using NOCC v1.14 webmail software
_______________________________________________________