What if we fail to give values in columns declared as NOT
NULL ?
Answer Posted / santy_rathod007@yahoo.co.in
Please correct the above error defintation :-
-407 :- An UPDATE, INSERT or SET VALUE is NULL, but the
object column defiend as NOT NULL values.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
When reorg is used?
What is dpf in db2?
What is a bind in db2?
Define declaration generator (dclgen).
How do you simulate the explain of an embedded sql statement in spufi/qmf?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
Where can you declare a cursor in a cobol-db2 program?
How do I add a column to an existing table in db2?
What is a buffer in memory?
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.
what is the role of the cursor in db2?
what is the sqlcode -501
What are the various isolation levels possible?
what is a corelated subquerry?
What is table space in db2?