Error Status 1492 executing a SQL procedure or function.

book

Article ID: 52797

calendar_today

Updated On:

Products

CA IDMS CA IDMS - Database CA IDMS - ADS

Issue/Introduction

Description

When invoking an SQL procedure or function, it fails with error:

DB347004 Vnn Tnnn no xxxxxxxx subschema areas map to DMCL using dbname yyyyyyy
DC172998 Vnn DBKEY=           STATUS=1492   BIND SUBSCHEMA-->xxxxxxxx
DC173001 Vnn APPLICATION ABORTED. SUBSCHEMA BIND FAILED; STATUS=1492

The 1492 error status indicates the DBNAME being used is missing one of the areas required.

The DBNAME used by the procedure or function can be inherited from the SQL session by specifying DEFAULT DATABASE CURRENT in the CREATE PROCEDURE or CREATE FUNCTION statement that defined the routine.

Solution

The DBNAME being used by the SQL transaction must contain the following segments:

  • The segment containing the database areas


  • The SQL catalog segment (areas DDLCAT, DDLCATLOD and DDLCATX)


  • The application dictionary segment (areas DDLDML and DDLDCLOD)


  • The SYSMSG segment

Environment

Release:
Component: IDMS