we will get the sql error code "-407" -407 :- An UPDATE, INSER

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

Question Posted / santy

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

Please Help Members By Posting Answers For Below Questions

Explain what are the various isolation levels possible?

676

What is the difference between oracle and db2?

675

What is rebind in db2?

668

How can you count the number of rows from a table tab?

722

What is the physical storage length of the data types date, time, and timestamp?

724

How can you quickly find out the # of rows updated after an update statement?

705

What is release/acquire in bind?

733

What is dclgen in db2?

777

List out the three types of page locks that can be held.

789

How do I copy a table in db2?

664

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

801

Mention the different locking levels that are available in db2.

730

How to check sequence on a table in db2?

691

What is a db2 tablespace?

688

What are the contents of dclgen?

744