How to resolve -407 sql code in DB2?
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 |
What type of database is db2?
If I have a view which is a join of two or more tables, can this view be updatable?
What is PRIME TABLE and what are the uses of it
What is a dbrm in db2?
How do you check for a null value in a db2 column?
can we view the access paths created by dbrm ? how ? thx
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?
What is the usage of open cursor command?
What is dbrm?
What is db2 command?
What are the different types of base tables?
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??