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 create db2 table in mainframe?
What is meant by union and union all?
What is dbrm? When it will be created?
Which component is responsible for processing sql statements and selecting access paths?
What is package in db2 mainframe?
How is the value function used?
Is db2 a programming language?
What are host variables in db2?
Is db2 relational database?
How do you select a row using indexes in db2?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
List some fields from sqlca?
What do you mean by commit and rollback?
What is the difference between cursor stability and repeatable read isolation levels?
What are the contents of dclgen?