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

Define declaration generator (dclgen).

1172

How to access db2 tables in mainframe?

1102

What is the difference between bind and rebind in db2?

1511

What is difference between rollback and commit?

1205

What is data manager?

1103

What are the various isolation levels possible?

1179

Define db2.

1171

Is it possible using max on a char column?

1192

What do you mean by storage group (stogroup)?

1080

Which isolation level provides maximum concurrency?

1203

What is role in db2?

1161

What is package in cobol db2?

1161

Which component is responsible for db2 startup and shutdown?

1084

What is host variable in db2 cobol?

1135

What are the uses of db2 optimizer?

1356