What if we fail to give values in columns declared as NOT
NULL ?

Answer Posted / santy

we will get the sql error code "-407"

-407 :- An UPDATE, INSERT or SET VALUE is NULL, but the
object column cannot contain the NULL values.

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is blu acceleration in db2?

608


Define db2.

672


Define declaration generator (dclgen).

669


How to rename a table in DB2 ?

641


How do I add a column to an existing table in db2?

592






What are the prerogatives?

617


What happens in bind step in a db2 program?

569


What is performance tuning db2?

620


What is db2 connect?

611


How do I delete a table in db2?

651


How can you classify the locks in db2?

636


Describe major components of db2?

642


How can we retrieve the total number of records in RPG & CLLE?

203


What is runstats utility in db2?

569


How to resolve deadlock issue

17991