Interested to Buy Any Domain ? << Click Here >> for more details...
How to resolve -407 sql code in DB2?
- 9 Answers
- 31616 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / king
This error occures when you are assigning NULL value to NOT
NULL column.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / lu
u have to check in DCLGEN if this column is null or not.
| Is This Answer Correct ? | 0 Yes | 1 No |
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 does the processing of a correlated subquery differ from a non correlated subquery?
What is deadlock in db2?
What's The Percentage Free Space ?
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
Define db2.
What is netezza database?
What is meant by repeatable read?
what is the name of the default db2 catalog database?
What do you mean by between and in? Is between inclusive of specified range values?
What is ibm db2 used for?
Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.
Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?
COBOL 
