What is the difference between base table and view?

Answer Posted / papal dabar

views are depandent on base table

Is This Answer Correct ?    15 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is innodb buffer pool?

564


How can you count the number of rows from a table tab?

637


What is rct?

751


What is a plan and package in db2?

625


What is page size in db2?

563






What is a bind card?

681


What is declare cursor?

613


How do I delete a column in db2?

680


What is the difference between cursor and select statement?

615


What is bufferpool in db2?

580


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 .....

1897


What is ibm db2 client?

523


Explain about cursor stability?

623


What is runstats utility in db2?

569


What is the physical storage length of time data type?

673