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 reorg in DB2
How can you quickly find out the number of rows updated after an update statement?
What are the three types of page locks that can be held?
How do you retrieve the data from a nullable column?
pls tell me abt the normalization five types....
Explain db2.
what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?
Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.
What is phantom read in db2?
On which levels locks can be applied?
How to retrieve rows from a db2 table in embedded sql?
What are the four lockable units for DB2?