Answer Posted / sadiq afroze
Not all of them. Some views are updatable e.g. single table
view with all the fields or mandatory fields. Examples of
non-updatable views are views which are joins, views that
contain aggregate functions (such as MIN), and views that
have GROUP BY clause.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
Which command is used to remove all rows from a table?
What are the rules for db2 programming?
What is cursor in dbms?
How do I start db2 in windows?
What is runstats db2?
What is the syntax for FETCH in DB2 ?
What is check constraint. Explain with example.
Define declaration generator (dclgen).
How is a typical db2 batch pgm executed?
What is explain in db2?
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?
How do I delete a table in database?
What happens in bind step in a db2 program?
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 ?...
What is the maximum size of varchar data type in db2?