SQL statement gets DB001031 with 0371
search cancel

SQL statement gets DB001031 with 0371

book

Article ID: 189442

calendar_today

Updated On: 06-20-2024

Products

IDMS IDMS - Database

Issue/Introduction

An IDMS SQL statement is failing with DB001031 and an error-status of 0371.
Errors may also indicate the the problem record/table is S-010 and the problem area is DDLDML.

Environment

Release: All supported releases.
Component: SQL Option.

Cause

The most likely cause of this error is that this is SQL being issued against a network-defined database, and the SQL engine is unable to access the required network schema.

Resolution

IDMS cannot access the network schema. Check for the following:

  1. Does the network schema exist?
  2. Check that it has been VALIDATEd.
  3. Make sure the DBNAME in use includes the required dictionary segment (the one containing the network schema).