Interested to Buy Any Domain ? << Click Here >> for more details...
What if we fail to give values in columns declared as NOT
NULL ?
- 3 Answers
- 9934 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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 |
On the create tablespace, what does the CLOSE parameter do?
What information is used as input to the bind process?
difference between group clause and order clause
What are the levels of isolation available with DB2V4
what is + sign and -ve sign for sql code ?
What is a system catalog table in db2?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.
what happend with out using Commit,when closing cursor and program?
why we create view.
What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?
Can you tell me how can you find out the # of rows updated after an update statement?
COBOL 
