What if we try to insert the base table through updatable view , but failed to

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

1 Answers
6523 Views
Cap Gemini, I also Faced
E-Mail Answers

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

Write a query to extract first 5 characters of a name in the column Stud_Name?

1 Answers RBS,

I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.

1 Answers Cap Gemini,

how will you retrieve first record in table

1 Answers UST,

What is the difference between drop table and delete table?

0 Answers

What is ibm db2 database?

0 Answers

What does the sqlcode of -818 pertain to?

3 Answers

What is the usage of open cursor command?

0 Answers

How to access db2 tables in mainframe?

0 Answers

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

0 Answers

What is the physical storage length of time data type?

0 Answers

what is the name of the default db2 catalog database?

3 Answers IBM,

can you use symbolic parameters in JOB?

5 Answers IBM,

For more DB2 Interview Questions Click Here