Even if we update the view, the data will update in the 
base table of the view.

Bit Map and B-tree index

That Host Variable contain the Truncated value when Null 
Indicator conatin value -2.

get error code "-407"

-407 :- An UPDATE, INSERT or SET VALUE is NULL, but the 
object column defined as NOT NULL values.

Sorry for the above answer :(

Please see the Correct answer, we will get the SQL error -
305

-305:- The NULL value cannot be assigned to output host 
variable number because no indicator variable is specified.

it will retrive the garbage value.

Please correct the above error defintation :-

-407 :- An UPDATE, INSERT or SET VALUE is NULL, but the 
object column defiend as NOT NULL values.

we will get the sql error code "-407"

-407 :- An UPDATE, INSERT or SET VALUE is NULL, but the 
object column cannot contain the NULL values.

in DROP TABLE command it will remove the table containts as 
well as table structure from the database catalog, also it 
release all the storage space it has acquired previously.
we can't rollback it as it is a ddl command.

but in case of DELETE TABLE command it just delete all the 
records but not relaese the spaces it acquires .it can be 
rollback as it is a dml command.

DROP TABLe deletes the entire Structure of the TABLE from 
the database with all the datas it contain, DELETE TABLE 
deletes only the rows of the TABLE.

drop table deletes the entire structure from the database 
and it also removes entry from syscat.tables. but where as 
delete table  only deletes the rows in the table.

we will get the sql code "-305".

-305:- The NULL value cannot be assigned to output host 
variable number because no indicator variable is specified.

Busschema is the way to identify the conformed dimentions 
across the business processies known as datamarts

Surragate Key: It is a system generated Key and used to 
eliminate the redundancy in the primary key.Its act as a 
Primary key.so there are always integers.

StarSchema: It is a logical database implement physically 
in the datawarehouse with centralized fact table 
normalized, depends on the denormalized dimension 
table.Advantages of starschema is slicing down,performance 
increase and easy to understand the data.