1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

How to resolve -407 sql code in DB2?

Question Posted / vikram and mangesh

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

Could anyone clearly explain the diference between sub query and correlated sub query?

3 Answers  

Explain about open switch business continuity software?

0 Answers  

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

2 Answers  

What is cascading rollback?

0 Answers  

What is -904 sql code? How to resolve it?

3 Answers  




Mention the various locks that are available in db2.

0 Answers  

wht steps we need will coding cobol and db2 pgm ?

6 Answers   CGI,

What is a host variable?

3 Answers  

Where to download IBM DB2 Certification Dumps for the below: C2090-311 : IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 C2090-312 : IBM DB2 11 DBA for z/OS C2090-313 : DB2 11 Application Developer for z/OS C2090-317 : DB2 11 System Administrator for z/OS C2090-541 : DB2 9.7 DBA for Linux UNIX and Windows C2090-543 : DB2 9.7 Application Development C2090-544 : DB2 9.7 Advanced DBA for LUW C2090-545 : DB2 9.7 SQL Procedure Developer C2090-546 : DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade C2090-610 : DB2 10.1 Fundamentals C2090-611 : DB2 10.1 DBA for Linux, UNIX, and Windows C2090-612 : DB2 10 DBA for z/OS C2090-614 : DB2 10.1 Advanced DBA for Linux UNIX and Windows C2090-615 : DB2 10.5 Fundamentals for LUW C2090-617 : DB2 10 System Administrator for z/OS C2090-730 : DB2 9 Family Fundamentals C2090-733 : DB2 9 Application Developer C2090-735 : DB2 9.5 SQL Procedure Developer C2090-737 : DB2 9 System Administrator for z/OS Exam

1 Answers   Mphasis,

Can we insert update delete in view?

0 Answers  

What is db2 bind process?

0 Answers  

How to update more then one record using update?

5 Answers   IBM,

For more DB2 Interview Questions Click Here
Categories