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

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

1975


What is a plan and package in db2?

1043


How to connect to db2 database from windows command line?

1000


What is deadlock in db2?

1017


Is it possible using max on a char column?

1084


Mention the definition of cobol in varchar field.

1179


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

1058


What parameters are used to control the free space in DB2?

1009


What is phantom read in db2?

1071


Define sqlca.

1055


What is cascading rollback?

1133


What is host variable?

1011


How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2167


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

2008


Explain db2.

991