Convert a string into a numeric value

[rafs]

Is it possible to convert a string to a numeric value using AS/400 query tool (strqry)? How?
thanks

Rafael

 

[iSeriesCodePoet]

Why would you need to do that? Just out of curiousity. Mike Wills
AS400 Programmer

http://www.koldark.net

Please, if you find my post useful, let me know.

 

[rafs]

I want to copy a spool file to a physical file (cpysplf), then run a qry to separate several columns, and transform some of them in numeric data, to make calculus.

Rafael

 

[iSeriesCodePoet]

How about writting an RPG program to do that. It would process very fast. Mike Wills
AS400 Programmer

http://www.koldark.net

Please, if you find my post useful, let me know.

 

[rafs]

Hi Mike,
i don't know much rpg language. Can you help me?
tanks.

Rafael

 

[iSeriesCodePoet]

In RPG you can use a %substr() (or %subst(), I forgot which) BIF (built-in-function) to parse out your data. So you just read through the file like normal and have several 'eval' and 'move' statements to get get the date how you want into the file.

If you read IBM's RPG manual, it will give you the parameters needed. Mike Wills
AS400 Programmer

http://www.koldark.net

Please, if you find my post useful, let me know.