What is the difference between base table and view?
Answer Posted / ankit
base tables have physical table which does havefacility to
select any condition and save but view is part of a base
table but diffrence is in view we can select columns and
rows using conditions in view creating
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
What is consistency token in db2?
What is a Foreign Key?
Where can you declare a cursor in a cobol-db2 program?
Which component is responsible for db2 startup and shutdown?
What is netezza database?
What is data manager?
What is deadlock in db2?
What are the various data types available in db2?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
What is db2 connect?
What does reorg do 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 .....
Name the lockable units in DB2?
What is a storage group (stogroup)?
What is the use of db2?