Null and Spaces in a field
Posted: Mon Jan 07, 2008 11:04 am
Hi,
I have a field ABC which is X(35) coming from Mainframe wherein the value looks like this in hexadecimal: X'000000000000000000000000000000000000404040404040" in this fashion. This field when it is colum exported gets truncated and causes problem. Is there a way to Handle this using IsNull.
Tried the following:
Moved ABC[1,1] to X(1) temporary field and did a IsNull(temporary field) and it doesn't help.
Any directions on how to crack this?
I have a field ABC which is X(35) coming from Mainframe wherein the value looks like this in hexadecimal: X'000000000000000000000000000000000000404040404040" in this fashion. This field when it is colum exported gets truncated and causes problem. Is there a way to Handle this using IsNull.
Tried the following:
Moved ABC[1,1] to X(1) temporary field and did a IsNull(temporary field) and it doesn't help.
Any directions on how to crack this?