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.
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)