Re-creating the VIEWDDL definitions for an IDMS SQL catalog can be a sensitive operation, particularly if IDMS Visual/DBA is installed. This is due to the fact that the some of the database entities created for Visual/DBA are created in schema SYSCA, which VIEWDDL creates. In order to re-run VIEWDDL, first DROP SCHEMA SYSCA; which means the Visual/DBA database entities also must be included in the DROP/CREATE operation.
Release: All supported releases.
Use the following as input to an IDMSBCF batch job://SYSIPT DD *
SET OPTIONS AUTOCOMMIT COMMAND;
CONNECT TO APPLDICT; <== change to appropriate dictionary name
// DD DISP=SHR,DSN=your.idms.srclib(VDB5UN18) <== uploaded from vdb5un18.sql in Visual/DBA
// DD *
DROP SCHEMA SYSCA CASCADE;
DROP SCHEMA SYSDICT;
// DD DISP=SHR,DSN=your.idms.CAGJSRC(VIEWDDL)
// DD DISP=SHR,DSN=your.idms.srclib(VDB5V18X) <== uploaded from vdb5v18x.sql in Visual/DBA