Hi all,
1)How to drop a unique constraint on a table

ex:
some thing similar to
Alter table ADMINISTRATOR.T Drop unique Constraint SQL050427161930230

2)How to create a materialized view in db2

3)I had a lozical view on a table using some function
inside the function i have written some audit information into the another table
but on selecting one column, i get audit fired for all columns.

Details: create table emp(enum int, ename varchar(20));

Create View "DB2ADMIN"."EMPX" as select cast(X_STRING(EAME)as VARCHAR(136) ) ENAME_X,
cast(X_STRING(EAME)as VARCHAR(136) ) ENAME_X from "DB2ADMIN"."EMP"

inside the X_STRING function i had written some audit actions.........
but on using "select ename_x from empx"
i get the audit for both column ,thou i can only one view ename_x information

internally the query is selecting both the columns,
Do i need to choose any options while creating the view to overcome this extra load to the database




Thanks
sirisha.M


DB2 & UDB email list listserv db2-l LazyDBA home page