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
- 6612 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 |
How do u achieve record level locking in DB2 versions when record level locking is not allowed?
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,
How do you find the maximum value in a column in db2?
Return code 100 means?
If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?
When the like statement is used?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq
What does the REORG Utility do?
My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .
Describe major components of db2?
How does DB2 use multiple table indexes?
COBOL 
