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.

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

0 Answers  

Why do we bind in db2?

0 Answers  

If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?

1 Answers   RBS,

How to view db2 table structure?

0 Answers  

What is the role of data manager in the db2 database?

0 Answers  

if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)

3 Answers  

What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.

3 Answers   IBM,

What is the significance of DB2 free space and what parameters control it?

1 Answers  

What techniques will be used to avoid deadlock??

5 Answers   IBM, SUN,

I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!

17 Answers   KNIT, Tech Mahindra,

When is the authorization check on DB2 objects done - at BIND time or run time?

1 Answers  

the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1

2 Answers   Logica CMG,