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
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 .....
Can we delete records from view?
What is dbrm? What it contains? When it will be created?
What is a db2 cursor?
What os does db2 run on?
Mention data types used in db2 ?
What is bind in db2?
What does runstats do in db2?
How to fetch the last row from the table in SQL (db2)?
What is a db2 package?
How do I start db2 in windows?
How does db2 sample database connect?
How to rename a table in DB2 ?
How connect db2 database to datastage?
What is clone table?