I have this:
1. A field-reference table (fieldref):
CREATE TABLE mylib/fieldref ( A CHAR (10) NOT NULL WITH DEFAULT, B CHAR (10) NOT NULL WITH DEFAULT, C DECIMAL (7 , 5) NOT NULL WITH DEFAULT, PRIMARY KEY (A))
2. A data table (myfile) created on the basis of the above fieldref table:
CREATE TABLE mylib/myfile AS (SELECT A, C FROM mylib/fieldref) WITH NO DATA
If I alter the attributes of a column (field) in my fieldref table, I would like the alteration to cascade to all tables created on the basis of fieldref; - is this functionality available with SQL ?
To clarify: An ALTER TABLE mylib/fieldref ALTER COLUMN a SET DATA TYPE CHARACTER (12) + ??? shall cause the a column in the myfile to also expand from 10 to 12 chars.
OS i v6r1 on Power i
August 30, 2010 8:21 PM
August 30, 2010 11:59 PM