What is a base table?

Answer Posted / s

Base table is created by using CREATE TABLE and the table
description is stored in Catalog table SYSTABLES. The
definition and data are persistant.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I import a csv file into db2?

564


define clustering index.

621


What do you mean by storage group (stogroup)?

584


Explain db2.

621


Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

628






What language is db2 written in?

597


Explain the contention situations caused by locks?

596


What is meant by union and union all?

591


ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

1599


What is dbrm? When it will be created?

602


What is a trigger in the db2 database?

598


What is scrollable cursor in db2?

586


How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

1711


What is host variable?

599


What is a db2 package?

601