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 ?

Answers were Sorted based on User's Feedback



What if we fail to give values in columns declared as NOT NULL ?..

Answer / 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

What if we fail to give values in columns declared as NOT NULL ?..

Answer / mani

the above mentioned will happen provided there is no default
value specified at the time of defining the table.

Is This Answer Correct ?    1 Yes 0 No

What if we fail to give values in columns declared as NOT NULL ?..

Answer / santy_rathod007@yahoo.co.in

Please correct the above error defintation :-

-407 :- An UPDATE, INSERT or SET VALUE is NULL, but the
object column defiend as NOT NULL values.

Is This Answer Correct ?    2 Yes 2 No

Post New Answer

More DB2 Interview Questions

Which component is responsible for db2 startup and shutdown?

0 Answers  


What is a DB2 bind?

1 Answers   Logica CMG,


What is the role of union all and union

0 Answers  


How to solved 818 error

4 Answers   Keane India Ltd, Wipro,


Are views updateable?

0 Answers  


What is SPUFI?

4 Answers  


What is runstats db2?

0 Answers  


Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

0 Answers   IBM,


What is a trigger in the db2 database?

0 Answers  


Define buffer pool.

0 Answers  


How does DB2 determine what lock-size to use?

2 Answers  


can we view the access paths created by dbrm ? how ? thx

2 Answers   IBM,


Categories