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
What is concurrency?
How many databases can be created inside an instance in db2 ?
How is deadlock resolved?
How to check last update on table in db2?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is cursor stability in db2?
is it compulsory commitment control in journal?
How can the duplicate values be eliminated from db2 select?
How does cobol compile db2 program?
What is nvl in db2?
What is the role of the data page in the db2 database?
How do you select a row using indexes in db2?
What is db2 and what is the use of db2 optimizer?
What are the various data types available in db2?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....