Error Status 1492 executing a SQL procedure or function.

Document ID : KB000052797
Last Modified Date : 14/02/2018
Show Technical Document Details

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