MVSFORUMS.com

dsonsamuel · Beginner Joined: 25 Mar 2004 Posts: 26 Topics: 16

Hi,
How can i cast a Char field in a table to integer type?Any thots?

regards,
dson.

kolusu · Posted: Thu Feb 09, 2006 11:31 am Post subject:

dsonsamuel,

why not simply use scarlar INT function ? Check this link which explains in detail about INT function.

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNSQH11/3.2.38?SHELF=&DT=20010718164132&CASE=

If that does not help show us examples of input and desired output along with their lengths.

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

dsonsamuel · Beginner Joined: 25 Mar 2004 Posts: 26 Topics: 16

Hi,
My concern is...

I have a amount fields in the table as 2, and 2,03 (CHAR 15)

I want to select the amount which exceeds a decimal amt limit for example 2 whcih is in working storage.

When I used cast(amt as decimal) it returned just the whole part which fails when the amt is 2,03 and limit is 2.

Is there any other solution to concert 2,03(char) to 2.03(Integer) and then do a compare with the limit 2?

Mervyn · Posted: Fri Feb 10, 2006 5:51 am Post subject:

Would it be easier to cast the number to char?
_________________
The day you stop learning the dinosaur becomes extinct

kolusu · Posted: Fri Feb 10, 2006 10:11 am Post subject:

dsonsamuel,

please show us examples of both input and desired output

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu