Alter table (z/OS):Extended alter instead of simple when change character length for table with view.
Steps to reproduce:
1. Create table with view
CREATE TABLE TOAD.ANN2 (
A INTEGER,
C CHARACTER(12) );
CREATE VIEW TOAD.VIEW
( A, C ) AS
SELECT * FROM TOAD.ANN2;
2. Open Alter Doe
3. Change length for column C (from 12 to 15)
4. Show script
Expected result:
ALTER TABLE TOAD.ANN2
ALTER COLUMN C SET DATA TYPE CHARACTER(15);
Actual result:
Extended alter (DROP + CREATE)
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center