What are db2 error codes -305 and -407. What is the
difference between these 2 error codes ?
Answer / 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 |
if i made sme changes in sub pgm wht r the things to be done for this ?
EXPLAIN has output with MATCHCOLS = 0. What does it mean?
what is plan? is plan executable or package?
Can you Average the Characters ?
What is a root page?
Where do you specify them?
Is it possible using max on a char column?
Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?
What is the size of a data page?
How do I import a csv file into db2?
What is runstats db2?
What is the physical storage length of timestamp data type?