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
- 9767 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 |
assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it
Can we insert update delete in view?
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
What is the information associated with sysibm.syslinks table?
What is the meaning of -805 SQL return code?
Explain the contention situations caused by locks?
Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?
What is deadlock in db2?
How do you stop a db2 database in linux?
Is it possible to precompile if db2 goes down?
What is RUNSTATS?
Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.
COBOL 
