If I have a view which is a join of two or more tables, can
this view be updatable?
Answer Posted / guest
If view has join that time view can not be updatable.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What are bind parameters in db2?
What are the various isolation levels possible?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is load utility in db2?
What are the contents of dclgen?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
How do I import data from excel to db2?
What is the difference between spufi and qmf?
Is db2 a mainframe database?
What are iseries servers?
Why do we use cursor?
How can you find out the # of rows updated after an update statement?
What is the difference between dbm cfg and db cfg file in db2 ?