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 |
What is the purpose of the WHENEVER statement?
What is the syntax required for the creation of a cursor?
How to insert more than one record using insert?
How can you compare table column after update and before update?
Give the COBOL definition of a VARCHAR field.
How we create a tables in db2,what is the process/syntax to create a table with example plz?
What is db2 instance?
What is the advantage in De-normalizing tables in DB2?
How many sub queries can you combine together ?
What are data types?
EXPLAIN has output with MATCHCOLS = 0. What does it mean?
What is db2?