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 scrollable cursor in db2?
What are the two types of logging in the db2 database? Explain them.
What is FREEPAGE and PCTFREE in TABLESPACE creation?
What is bind plan?
what is rebinding ?
What is deadlock?
what is diffrence b/w file-aid tool and file-aid utility???
define clustering index.
Give a brief description of db2 isolation levels?
Define data page.
Is schema the same as database?
wht is d/f between union and joins ?