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 are db2 tables?
What is catalog database in db2?
What are the three DB2 date and time data types and their associated functions?
Can i insert bulk records into a db2 table using qmf of spufi only............!!!
What is copy pending status in db2?
Can you tell me how can you find out the # of rows updated after an update statement?
What is the maximum No of rows per page?
the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1
Name the lockable units in DB2?
What is FREEPAGE and PCTFREE in TABLESPACE creation?
What is the function of the Data Manager?
how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures