wt is view ? wht r the restrictions for view ?
Answer Posted / rajesh
View is just a display of a DB2 table where the access to
that view can be controlled.
Restriction : In order to create a view a base table should
exist.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is the physical storage length of the data types date, time, and timestamp?
How do I delete a table in database?
Is ibm db2 open source?
What is explain plan in db2?
What is temporal table in db2?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
List out the three types of page locks that can be held.
What is the purpose of rollback and commit?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
Explain dclgen.
i want to maintain uniqueness on pdf without make lf??????????
Is db2 a database?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What is dbrm? What it contains? When it will be created?
What db2 400?