What is the difference between base table and view?
Answer Posted / bhushan
Base table is the Physical table and views are the virtual
tables where its physical existence will not be there.
| Is This Answer Correct ? | 21 Yes | 2 No |
Post New Answer View All Answers
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What does db2 plan contain?
What is check constraint. Explain with example.
What does sqlcabc has?
How to find primary key of a table in db2?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
Are views updateable?
Which isolation level provides highest data integrity?
What language is db2 written in?
What do you mean by commit and rollback?
What does reorg do in db2?
what is the responsibility of the construction superintendent
What is the physical storage length of date data type?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What are iseries servers?