Answer / kk

Hi,

The coloumn declare not null.but we can try to inserted or
update that coloumn means -407 error will come.

Answer / anandrao

This error occures when you are assigning NULL value to NOT
NULL column.
You can wrap the variable with coalesce/value and default
it but it is totally dependant on business logic.

Answer / kk

hi,
sorry above answer coloumn difine not null but we are to
inserted null values that time -407 will come.

Answer / vikram and mangesh

yes but what are the different ways to resolve this
error.where will we check???

Answer / sathish kumar.b

hi.............
while retrieving data if any null values found in this
case -407 will occur.
how to resolve -407 is declare the null indicator variables.

Answer / king

This error occures when you are assigning NULL value to NOT
NULL column.

Answer / lu

u have to check in DCLGEN if this column is null or not.

Answer / vishal

The Error is not -407 for Null indicator but it is -307.
It should be handled carefully using host varaible in Pgm.

Answer / srinivas chennareddy

You can use null indicators.

If I have a view which is a join of two or more tables, can this view be updateable?

0 Answers  

What db2 400?

0 Answers  

What is a NULL value? What are the pros and cons of using NULLS?

2 Answers  

how will you retrieve first record in table

1 Answers   UST,

What is a DBRM, PLAN ?

3 Answers  

What is the difference between nvl and coalesce?

0 Answers  

OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.

1 Answers   Syntel,

What is null in db2?

0 Answers  

What does sqlcabc has?

0 Answers  

Can one database have multiple instances?

0 Answers  

What is reorg in database?

1 Answers  

Explain about rct.

0 Answers