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

Why do we bind in db2?

903


Explain what are the various isolation levels possible?

835


What is the syntax for creating a table in the db2 database?

894


How do I connect my db2 database to ibm?

815


What's The Error Code For Unique Index Voilation?

912


Is ibm db2 open source?

851


What is db2 connect?

823


What is clone table?

815


What is the use of value function?

868


How will you return the number of records in table?

723


What is the physical storage length of date data type?

1017


What is meant by union and union all?

800


How can we retrieve the total number of records in RPG & CLLE?

403


What is plan in cobol db2?

811


I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

1871