How to resolve -407 sql code in DB2?

Answers were Sorted based on User's Feedback



How to resolve -407 sql code in DB2?..

Answer / kk

Hi,

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

Is This Answer Correct ?    12 Yes 3 No

How to resolve -407 sql code in DB2?..

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.

Is This Answer Correct ?    8 Yes 2 No

How to resolve -407 sql code in DB2?..

Answer / kk

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

Is This Answer Correct ?    5 Yes 5 No

How to resolve -407 sql code in DB2?..

Answer / vikram and mangesh

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

Is This Answer Correct ?    2 Yes 2 No

How to resolve -407 sql code in DB2?..

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.

Is This Answer Correct ?    2 Yes 2 No

How to resolve -407 sql code in DB2?..

Answer / king

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

Is This Answer Correct ?    1 Yes 1 No

How to resolve -407 sql code in DB2?..

Answer / lu

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

Is This Answer Correct ?    0 Yes 1 No

How to resolve -407 sql code in DB2?..

Answer / vishal

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

Is This Answer Correct ?    0 Yes 1 No

How to resolve -407 sql code in DB2?..

Answer / srinivas chennareddy

You can use null indicators.

Is This Answer Correct ?    1 Yes 4 No

Post New Answer

More DB2 Interview Questions

What type of database is db2?

0 Answers  


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

3 Answers  


What is PRIME TABLE and what are the uses of it

1 Answers  


What is a dbrm in db2?

0 Answers  


How do you check for a null value in a db2 column?

2 Answers  


can we view the access paths created by dbrm ? how ? thx

2 Answers   IBM,


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?

2 Answers  


What is the usage of open cursor command?

0 Answers  


What is dbrm?

0 Answers  


What is db2 command?

0 Answers  


What are the different types of base tables?

0 Answers  


My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??

2 Answers   Xansa,


Categories