What if we fail to give values in columns declared as NOT
NULL ?
Answers were Sorted based on User's Feedback
Answer / santy
we will get the sql error code "-407"
-407 :- An UPDATE, INSERT or SET VALUE is NULL, but the
object column cannot contain the NULL values.
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / mani
the above mentioned will happen provided there is no default
value specified at the time of defining the table.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
What is query_cache_limit?
What is the logical entity between plan and Package?
Explain packages.
what is the process of precompiler?
What is DCLGEN ?
What is the difference between group by and order by?
define clustering index.
what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain?
3 Answers Cap Gemini, Tech Mahindra,
explain about index with examples
how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...
How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.
Q3. How will you fetch duplicate values from a DB2 table?