This document describes the cause of a 1494 in the VIEWDDL jobstep.
Release : All supported releases.
Component : CA IDMS/DB
The first thing VIEWDDL needs to do is to define an SQL schema for the non-SQL dictionary schema.
It uses this syntax:
CREATE SCHEMA SYSDICT
FOR NONSQL SCHEMA SYSDIRL.IDMSNTWK VERSION 1;
IDMSNTWK version 1 must be the dictionary network schema defined in an appropriately "DIRL"ed dictionary.
In the above syntax, that DIRLed dictionary is SYSDIRL.
In a normal IDMS install, a DIRL'ed dictionary is created and named according to VARBLIST parameter DIRL#DBN which defaults to SYSDIRL.
If this parameter was changed during the install, the source of VIEWDDL must also be changed so that the definition of SCHEMA SYSDICT will be successful.
Failure to do so will cause that CREATE statement to fail with a 1494 error-status.