Error Status 1492 executing a SQL procedure or function.

Products

• IDMS
• IDMS - Database
• IDMS - ADS

Issue/Introduction

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.

 

Environment

IDMS - all supported releases

Resolution

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

• The segment containing the database areas being accessed

• The SQL catalog segment (areas DDLCAT, DDLCATLOD and DDLCATX) where the SQL schema.tables are defined
  
  
• The application dictionary segment (areas DDLDML and DDLDCLOD)
  
  
• The SYSMSG segment