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.

DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language

4 Answers   Accenture,

What is explain plan in db2?

0 Answers  

can all users have the privilage to use the sql statement select * (dml)?

0 Answers   IBM,

What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?

4 Answers  

What is a Resource Control Table(RCT)? Describe its characteristics.

3 Answers  

we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?

2 Answers  

What's The Error Code For Unique Index Voilation?

0 Answers   IBM,

what are stage one indexable predicates?

1 Answers  

cobol-db2 runjcl please?

2 Answers   DELL,

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

0 Answers  

In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.

5 Answers   CTS,

What is the physical storage length of time data type?

0 Answers