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 is rct?

1182

Can you tell me how can you find out the # of rows updated after an update statement?

1052

What are union and union all?

934

How many types of page locks can be held in db2?

1000

What are the two types of logging in the db2 database? Explain them.

1027

Is it possible using max on a char column?

1092

What is buffer pool and list some of them?

992

what is the responsibility of the construction superintendent

2092

How to find the maximum value in a column in the db2 database?

1029

How to find the number of rows in db2 tables?

1007

What is lock escalation in db2?

976

What is db2 optimizer?

1190

How do I import a csv file into db2?

946

How to get the ddl of a table in db2?

1082

What is cobol db2?

943