Alter table (z/OS):Extended alter instead of simple when change character length for table with view (4333935)

Converse agora com nosso suporte

Voltar

Título

Alter table (z/OS):Extended alter instead of simple when change character length for table with view
Descrição

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)

Login necessário

é necessário estar conectado e ter um contrato de manutenção atual para visualizar os artigos de conhecimento premium.

Conteúdo recomendado