wt is view ? wht r the restrictions for view ?

Answer Posted / anjireddy vintha

view is a logical object which is derived from parent
table. view will be deleted automatically when patent table
is deleted.

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is cascading rollback?

611


Name the lockable units in DB2?

655


What are union and union all?

529


Why select is not preferred in embedded sql programs?

697


What is runstats and reorg in db2?

781






How can deadlocks be resolved?

531


When the like statement is used?

623


Define check constraint.

633


How does cobol compile db2 program?

595


How to take backup of table in db2?

589


What's The Error Code For Unique Index Voilation?

642


What is copy pending status in db2?

623


Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

1881


How to execute stored procedure in db2 command editor?

522


Explain about dbrm.

599