What are db2 error codes -305 and -407. What is the
difference between these 2 error codes ?



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

Post New Answer

More DB2 Interview Questions

What is the FREE command?

1 Answers  


Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.

1 Answers  


What is the role of data manager in the db2 database?

0 Answers  


How does db2 sample database connect?

0 Answers  


What types of tables are there in the db2 database?

0 Answers  






What is the maximum size of varchar data type in db2?

0 Answers  


What is db2 bind process?

0 Answers  


How do you eliminate duplicate values in db2?

0 Answers  


What are the contents of dclgen?

0 Answers  


Is db2 free?

0 Answers  


How many databases are there?

0 Answers  


i want to maintain uniqueness on pdf without make lf??????????

0 Answers  


Categories