Null handling

kab123 · Post by **kab123** » Thu May 19, 2005 9:12 am

Hello,

Does IsNullStr() and IsNull really have any difference..
I am anxious to know If IsNullStr() treates 10 bytes of spaces and a null and a blank equally as null..
If not, Is there anyother function or Transform that treats all the above scenarios as Null..bacause In my scenario I may get different format of files, and I feel for some reason The above function works sometimes and doesn't work sometimes...
Any advice !!

ArndW · Post by **ArndW** » Thu May 19, 2005 9:28 am

kab123,

I know that the IsNull() function returns true for any string that contains an SQL null in it (this is, I think, a CHAR(128)). I haven't used the IsNullStr() function but will look at it - it is odd that one would have two identical functions...

ArndW · Post by **ArndW** » Thu May 19, 2005 9:32 am

kab123,

umm... I feel inadequate... Just created a server job and tried IsNullStr('hello world') and it wouldn't compile, plus I couldn't find the function in the documentation, either... Could this be a user-written function at your site?

chulett · Post by **chulett** » Thu May 19, 2005 9:41 am

I thought IsNullStr comes from the PX side.

If it's user written, then I would hope that someone there should be able to "fix" it so it always works as expected. At worst case, post the code.

roy · Post by **roy** » Sun May 22, 2005 12:39 am

Hi,
I can understand the

.
posting in the EE forum asking of PX and Server routines
and posting server in the job type.

Are you using a mix of server and PX jobs and experiancing differences in behaviour?

You might want to make the situation and the question more clear so people might answer a worthy response.

Till then I doubt you'll get anything out of this post.

IHTH,