Null and Spaces in a field

vijayrc · Post by **vijayrc** » 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?

ArndW · Post by **ArndW** » Mon Jan 07, 2008 11:21 am

I am working with columns containing similar values. In my case, I added a filter of "tr '/000' '?'" to replace the 0x000 nulls with question marks in the string.

n.b. 0x000 is NUL, not an SQL NULL!

vijayrc · Post by **vijayrc** » Thu Jan 10, 2008 7:48 am

ArndW wrote:I am working with columns containing similar values. In my case, I added a filter of "tr '/000' '?'" to replace the 0x000 nulls with question marks in the string.

n.b. 0x000 is NUL, not an SQL NULL ...

ArndW,
What I did is take this X(35)'s first two bytes into a single byte field and check for Null as described in the manual [1 + NullToZero[field1] + NullToZero[field2]] and check if the result is 1 for Null...
Thanks for your input though. If you have better way of resolving this, let me know