Db2 sql where is null

Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Does ES6 make JavaScript frameworks obsolete? Podcast Do polyglots have an edge when it comes to mastering programming Featured on Meta.

Based upon your most recent response, you may want to investigate your bulk load process. It may be that there are some data rows being loaded that have datatype mismatches with the target tables. If yes, then it will load Blank values or spaces as well.

No Account? Sign up. By signing in, you agree to our Terms of Use and Privacy Policy. Already have an account? Sign in. By signing up, you agree to our Terms of Use and Privacy Policy. Meaning: -1 : the field is null 0 : the field is not null -2 : the field value is truncated.

Every column defined to a DB2 table must be designated as either allowing or disallowing nulls. Null is the default if nothing is specified after the column name. The purposes of the indicator variable are to: 1 Specify the null value.

A negative value of the indicator variable specifies the null value. Improve this answer. MadMurf MadMurf 2, 2 2 gold badges 21 21 silver badges 29 29 bronze badges. I voted up the accepted answer as well, but I'm using yours instead. Kamruzzaman Md. Kamruzzaman 1, 14 14 silver badges 25 25 bronze badges. Chris Shaffer Chris Shaffer Select Product. Jnn Jnn 4 4 bronze badges.

Er, yes. Taryn k 54 54 gold badges silver badges bronze badges. COALESCE is different in that you can feed it a variable number of parameters and it will return the first non-null, with an optional default.