What are db2 error codes -305 and -407. What is the
difference between these 2 error codes ?
Answer Posted / amarnadh reddy
Hi,
-305 is Null Indicator is needed. The null value cannot be
assigned to output host variable. Because no Indicator
variable is specified. (to fetch or select operation
resulted in the retrieval of a null value to be inserted
into the output host vaariable)
-407 is An update or insert value is null. but the object
column name cannot contain null values.(the update or insert
value was null. But the object column was declared as not
nullin the table)
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
How to find primary key of a table in db2?
Is db2 free?
How would you find out the total number of rows in a db2 table?
What is catalog database in db2?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
Explain how can you do the explain of a dynamic sql statement?
What is host variable in db2 cobol?
What is the picture clause of null indicator variable?
What is the difference between oracle and db2?
What is reorg and runstats in db2?
What is an instance database?
Can you tell me how can you find out the # of rows updated after an update statement?
Give a brief description of db2 isolation levels?
What are foreign keys in db2?
What happens in bind step in a db2 program?