Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

What is database manager in db2?

1020


If I have a view which is a join of two or more tables, can this view be updateable?

1139


Define db2 and its databases?

1055


How to rename a table in DB2 ?

1088


How can you do the explain of a dynamic sql statement?

1069


What is db2 plan table?

1049


What is difference between alias and synonym in db2?

1140


What is performance tuning db2?

1061


What are foreign keys in db2?

1103


I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

3207


What is db2?

1182


Is ibm db2 free?

1009


What is the difference between bind and rebind in db2?

1450


How is deadlock resolved?

1146


Why db2 is called db2?

1039