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...

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

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

Question Posted / mangesh

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

What is dbrm? When it will be created?

0 Answers  

if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.

8 Answers   Wipro,

Is db2 a programming language?

0 Answers  

What is dbrm library?

0 Answers  

What is cascading rollback?

0 Answers  

Do we need cursor for Count(*)?

4 Answers   iGate,

What is innodb buffer pool?

0 Answers  

Can one database have multiple instances?

0 Answers  

What is the difference between static and dynamic SQL?

1 Answers  

Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?

2 Answers   Deloitte,

query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop

2 Answers   IBM,

What is an access path?

3 Answers  

For more DB2 Interview Questions Click Here
Categories