How to Handle primary key null handling

srao · Post by **srao** » Fri Apr 20, 2007 7:10 pm

How to Handle primary key null Handling in server jobs

DSguru2B · Post by **DSguru2B** » Fri Apr 20, 2007 8:54 pm

There is IsNull() function. You can use that to identify null values and constraint them or pass them down a reject link. If your source is a flat file you might also want to test for zero length.

chulett · Post by **chulett** » Fri Apr 20, 2007 10:53 pm

I'm curious... if there something special you are looking for? If so, you'd have to be more explicit what 'primary key null handling' means to you so we can answer the right question.

Or can we assume, like our friend has, that you just mean plain old null detection - in which case the IsNull() or 'trim and test for zero length' advice already given is enough?

Let us know!

ray.wurlod · Post by **ray.wurlod** » Sat Apr 21, 2007 2:12 am

If this is a user requirement - or a PHB requirement - just yell in their face that a primary key is, by definition, NOT NULL.

chulett · Post by **chulett** » Sat Apr 21, 2007 6:25 am

Right - guessing the OP wants to know how to avoid sending NULL values to a PK. However, given the vagueness of the question...