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
What is cascading rollback?
Name the lockable units in DB2?
What are union and union all?
Why select is not preferred in embedded sql programs?
What is runstats and reorg in db2?
How can deadlocks be resolved?
When the like statement is used?
Define check constraint.
How does cobol compile db2 program?
How to take backup of table in db2?
What's The Error Code For Unique Index Voilation?
What is copy pending status in db2?
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 .....
How to execute stored procedure in db2 command editor?
Explain about dbrm.