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 |
How can you compare table column after update and before update?
What is the difference between dbm cfg and db cfg file in db2 ?
Update command
how to resolve -811 error. give clear explination
How does DB2 use multiple table indexes?
What is the difference between primary key & unique index ?
What is null indicator in db2?
pls tell me abt the normalization five types....
What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.
4 Answers Cap Gemini, Verizon,
What's The Percentage Free Space ?
What are the advantages of using a PACKAGE?
a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.