1494 error status in VIEWDDL

Products

• IDMS
• IDMS - Database
• IDMS - ADS

Issue/Introduction

This document describes the cause of a 1494 in the VIEWDDL jobstep.

Environment

Release : All supported releases.

Component : CA IDMS/DB

Cause

Unable to identify the location of dictionary network schema IDMSNTWK.

Resolution

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.  

Additional Information

CA-supplied Dictionary Definitions: https://docops.ca.com/ca-idms/19/en/administrating/administrating-ca-idms-database/dictionaries-and-runtime-environments/ca-supplied-dictionary-definitions