How to compare Alpanumeric with Numeric Field

gayathrinag · New User Joined: 16 Oct 2008 Posts: 37 Location: chennai

Hi,

I have a requirement that i need to compare the Alphanumeric field with numeric field.
Example:

WS-FIELD1 06 A
WS-FIELD2 06 N

if WS-FIELD1 = WS-FIELD2
then do something.

But we cannt compare these,since both are different datatypes. I need help in comparing this.

And in my WS-FIELD1 i may have leading zeros (say 000110).

Can any one help me in this.

Thanks

expat · Posted: Wed Mar 02, 2011 7:50 pm

What have you tried and what were the results ?

gayathrinag · New User Joined: 16 Oct 2008 Posts: 37 Location: chennai

i have tried the following things

1) we tried to move the WS-FIELD1 Alphanumeric field to Numeric field and we tried to compare them but we got s0c 7 abend.

Bill O'Boyle · Posted: Wed Mar 02, 2011 8:14 pm

Most likely, there's data in WS-FIELD1, positions 1-5, which has a low-order (numeric) nibble which exceeds X'9'. But, position-6 could be the culprit as well.

When the comparison is issued (under the covers), a "Compare Pack" instruction is generated. This is because the data found in both fields is PACKED (zone-nibbles are discarded, except for position-6) before the "CP" instruction. Bad packed-data will cause a "CP" to raise a S0C7.

Please post (in hex, IE: 0 = X'F0') all of the data found in both fields.

Bill

dick scherrer · Posted: Wed Mar 02, 2011 9:25 pm

Hello,

What do these fields contain? Is the compare to determine if they are equal/unequal or something else?

If you show a few examples of the data and the result you want from a compare, we may be able to offer more suggestions.

dbzTHEdinosauer · Posted: Thu Mar 03, 2011 12:30 pm

why don't you redefine/move the numeric field to an alpha field and compare the alpha fields.

if you have non-numerics in your numeric field, you screwed anyway.

you could always do the validatation/compare in sort.