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

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

1904


What is the reason behind not using select * in embedded sql programs?

845


Explain various types of locks in db2?

881


Comment whether the cursor is closed during commit or not.

864


What is the role of data manager in the db2 database?

852


How can tablespace be moved to another dasd volume that is allocated for that tablespace?

975


What are the benefits of using the db2 database?

886


I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2146


Explain the function of data manager.

810


List some fields from sqlca?

804


What is the cobol picture clause of the db2 data types date, time, timestamp?

837


Explain about rct.

858


what is diffrence b/w file-aid tool and file-aid utility???

4530


Define check constraint.

840


How can record locking be achieved in those DB2 versions which do not support it?

834