IsNull() notworking
Posted: Tue Jul 26, 2011 1:04 pm
Hi ,
I have file with 4 columns. one of the column is notnull and length is 12 char.
But sometimes null value may come to this column. So while reading I am making as varchar and nullable yes in the file and reading.
I want to reject that record while loading into database.
I am using constrain, IsNotNull(col2). I did len(col2) >0 aswell.
that column have the null value so that record should not load into databse. But It is loading. I didn't see any special char.
I have file with 4 columns. one of the column is notnull and length is 12 char.
But sometimes null value may come to this column. So while reading I am making as varchar and nullable yes in the file and reading.
I want to reject that record while loading into database.
I am using constrain, IsNotNull(col2). I did len(col2) >0 aswell.
that column have the null value so that record should not load into databse. But It is loading. I didn't see any special char.