CA Datacom SQLCODE -185 update Datadictionary DATA-DICT database

Products

• Datacom
• DATACOM - AD
• Datacom/DB

Issue/Introduction

CA Datacom SQL update commands  (e,g, UPDATE, DROP)  against the Datadictionary DATA-DICT database fails with SQLCODE -185.

In DDOL Interactive SQL facility:

DDSQL01-ERROR OCCURRED EXECUTING A PLAN  -185

USER HAS NO MAINTENANCE AUTHORITY ON DATABASE:DATA-DICT

In Dataquery SQL mode:

DQ093E - USER HAS NO MAINTENANCE AUTHORITY ON DATABASE:DATA-DICT    CMD=QEXEC,SQLRC=0185-,ERRPGM=DBSERV  ,ERRD2=0000000002

 

Environment

Release : 15.1

Component : CA DATACOM SQL

Resolution

Datadictionary tables are read only via SQL.

There are special checks in the SQL engine for tables that are part of DATA-DICT. It disallows any updates to those tables.
An attempt to update them results in SQLCODE -185.

This is documented in the 15.1 Message description for SQL error -185:

Note

You cannot use SQL to do maintenance on the DATA-DICT database, that is, no maintenance can be done to any tables in the DATA-DICT database using SQL.

Use DDUPDATE or DDOL to update Datadicitonary entities. A Dataquery DQL query can still be used to update Datadictionary.