Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 1 Answers
- 6507 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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 |
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)
i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?
8 Answers Cap Gemini, CGI, EDS, IBM, Satyam, Wipro,
i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance
What is commit in db2?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
How to get the ddl of a table in db2?
How to resolve -818 sql code in DB2?
how to take the back up of the DB2 table.
Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?
What is a DB2 plan?
What is a buffer pool?
COBOL 
