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 the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?

2 Answers  

What is db2 connect?

1 Answers  

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

3 Answers  

What is a composite index and how does it differ from a multiple index?

1 Answers  

What does db2 plan contain?

1 Answers  

if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..

4 Answers   IBM,

i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

1 Answers   TATA,

What is a buffer pool?

2 Answers  

What is a page in db2?

1 Answers  

What is a trigger in the db2 database?

1 Answers  

cursor with hold explain ?

1 Answers   Verizon,

how to check the table is empty or not?

3 Answers   IBM,