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

What if we try to insert the base table through updatable
view , but failed to give a column value which is defined
as NOT NULL.

Question Posted / mangesh


What if we try to insert the base table through updatable view , but failed to give a column value..

Answer / santy

get error code "-407"

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

Is This Answer Correct ?    11 Yes 0 No

Post New Answer

More DB2 Interview Questions

How to know the primary key of a table without defining the primary key in the table?

5 Answers   Satyam,

what is the difference between declaring the cursor in WS section and Procedure division?

1 Answers   HCL,

can we drop column from a table

7 Answers   INDUS,

what is the process of precompiler?

2 Answers  

How do you do the EXPLAIN of a dynamic SQL statement?

2 Answers  




a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.

3 Answers  

What is scrollable cursor in db2?

0 Answers  

Explain correlated sub-queries.

0 Answers  

what is check point and restart Logic ? why do we go for that ??

2 Answers   CGI, UST, Xansa,

How to get Top 10 Salaries from a Table

11 Answers   Accenture, HTC,

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

0 Answers   JPMorgan Chase,

Can i insert bulk records into a db2 table using qmf of spufi only............!!!

2 Answers  

For more DB2 Interview Questions Click Here
Categories