Process bad data in packed field..

Virgon · New User Joined: 17 Jun 2005 Posts: 14 Location: Chennai

Hi all,

I ran into this situation and needs everyone help.

I have a 4 byte packed field defined in a file. In the program, if the field is populated with value I am using the field.

But, I have bad data like null values (x'00000000') and spaces (x'40404040') in some records in this field. Now, I wanted to compare the packed field with these values and if it is present, I wanted to move zeroes into it. I need to process these records, i cannot bypass it.

When I tried comparing, it gave me compilation error as expected. I wanted to know if they is a way to process it.

Please let me know.

Thanks,
Virgon

ap_mainframes · Posted: Thu Mar 23, 2006 8:50 am

Well I see couple of solutions here ( if I understand your problem correctly).

1. Check for that field agianst IS NUMERIC.
2. Why can we inspect that field for SPACE and NULL values and replace them with zeroes, instead of comparing???

Let us all know if this doesnt work.