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
i want to maintain uniqueness on pdf without make lf??????????
What is the reason behind not using select * in embedded sql programs?
Explain various types of locks in db2?
Comment whether the cursor is closed during commit or not.
What is the role of data manager in the db2 database?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What are the benefits of using the db2 database?
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?
Explain the function of data manager.
List some fields from sqlca?
What is the cobol picture clause of the db2 data types date, time, timestamp?
Explain about rct.
what is diffrence b/w file-aid tool and file-aid utility???
Define check constraint.
How can record locking be achieved in those DB2 versions which do not support it?