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


Please Help Members By Posting Answers For Below Questions

How can we retrieve the total number of records in RPG & CLLE?

180


How do I add a column to an existing table in db2?

578


What is page size in db2?

555


How many databases are there?

584


Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2313






Give the name of some fields form sqlca.

605


What is the maximum number of columns in a db2 table?

706


Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

614


Can we update view in db2?

547


If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

694


What is release/acquire in bind?

641


How can the duplicate values be eliminated from db2 select?

613


Which are the db2 tools to protect integrity of the database?

675


Why do chiropractors use drop table?

645


Is db2 a mainframe database?

555