Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com
SQLCode -672
Causa
OPERATION DROP NOT ALLOWED ON TABLE table_name.
The DROP operation failed for one of the following reasons:
The table being dropped has the RESTRICT ON DROP attribute.
The table space or database being dropped contains the specified table, which has the RESTRICT ON DROP attribute.
Ação do sistema
The DROP statement cannot be executed.
Resposta ao Desenvolvedor
Before dropping the table, alter the table, specifying DROP RESTRICT ON DROP.
For DROP TABLESPACE or DROP DATABASE, make sure that there are no other tables within the table space or database with the RESTRICT ON DROP
attribute.
The following SELECT statement can identify the tables:
SELECT CREATOR
, NAME
FROM SYSIBM.SYSTABLES
WHERE TYPE = 'T'
AND CLUSTERTYPE = 'Y'
AND DBNAME = 'database_name'
AND TSNAME = 'tablespace_name';
