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

What types of tables are there in the db2 database?

1048

Give a brief description of db2 isolation levels?

1061

What is universal database?

1066

What is reorg and runstats in db2?

1213

What is dbrm? What it contains?

1161

What is the use of runstats in db2?

1101

Which command is used to remove all rows from a table?

1103

Explain the contention situations caused by locks?

1065

How do I import data from excel to db2?

1060

What are catalog tables in db2?

1041

i want to maintain uniqueness on pdf without make lf??????????

2151

What is the use of predicate?

1039

Is db2 free?

1084

What is a Foreign Key?

1091

What is concurrency?

1223