search cancel

DML035 error in IDMSDMLC on INCLUDE TABLE

book

Article ID: 189633

calendar_today

Updated On:

Products

IDMS IDMS - Database

Issue/Introduction

​Attempting to compile an IDMS/SQL cobol program.
IDMSDMLC issues the following error message:

DML035 SQL MESSAGE -- INCTBL SQLCODE=-6,ERC=1031                                                  CC = 16

Cause

The DICTNAME parameter in the SYSIDMS ddname of the IDMSDMLC step is specifying a DBNAME which includes no catalog segment.

Environment

Release : 19.0

Component : CA IDMS SQL

Resolution

If the DICTNAME identifies a dbname which includes a valid SQL catalog but just doesn't contain the SQL table being INCLUDEd, then a friendly error is returned.

E DML013 TABLE NOT FOUND IN CATALOG

However, if the DICTNAME identifies a dbname which has no catalog, the undocumented message DML035 is issued.

DML035 SQL MESSAGE -- INCTBL SQLCODE=-6,ERC=1031                                                  CC = 16

Make sure the DICTNAME parameter in the SYSIDMS ddname of the IDMSDMLC step identifies the correct dbname.