What if we try to insert the base table through updatable
view , but failed to give a column value which is defined
as NOT NULL.
Answer / santy
get error code "-407"
-407 :- An UPDATE, INSERT or SET VALUE is NULL, but the
object column defined as NOT NULL values.
| Is This Answer Correct ? | 11 Yes | 0 No |
What is lock escalation in db2?
What does runstats do in db2?
What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?
What is null indicator in db2?
wht displays the number of times a query modified ?
Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2 how will we do this. We can create a single program and a single load for this program.
How do I change the column size in db2?
What is cursor in dbms?
What is a cursor and what is its function?
How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?
What is rebind in db2?
Hi. I am currently working as a application developer. I would like to persue a DB2 certification exam. Can anybody please provide me the details about this exam like Syllabus, Cost and how to take the certification?