Re: text to numeric BIF

[Gary Guthrie <garyguthrie@xxxxxxxxxxx>]

There are several ways to convert from character to numeric.

With V5R2, use built-ins %Dec, %DecH, %Int, %IntH, %Uns, $UnsH, and %Float

Here are a few ideas for pre-V5R2 releases...


Check out the January 31, 2002 issue of Club Tech iSeries Programming Tips
newsletter in which I provide a sample service program that uses MI built-in
_CVTEFN to convert from character to numeric. Procedure CvtCharToNum uses a 30.9
field for the numeric that it returns to the caller so that it can handle the
largest possible packed decimal value. Once back in the calling program, you can
use Eval or Eval(H) and put the result in a field of your chosen precision and
decimal places.

You can find the service program at

http://www.iseriesnetwork.com/resources/artarchive/index.cfm?fuseaction=viewarticle&CO_ContentID=13735&channel=art&PageView=Search


You can also use embedded SQL and use the Cast function to convert from
character to numeric. Also, with embedded SQL, you can use SQL's built-in scalar
functions:

BigInt - convert to big integer

Decimal (or Dec) - convert to decimal

Double (or Double_Precision) - convert to floating point

Float - same as Double

Integer (or Int) - convert to integer


Gary Guthrie


Peter Vidal wrote:
>   
> Mike, I have tried to look for and search for some way to work this out.  My
> favorite place (besides MIDRANGE) is http://search400.techtarget.com/ but
> neither there...
> 
> I am curious...did you find a way to do it?