2567957 - MFC seeing a SQLCODE = -312, when using the DB2 Caching Option. | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2567957 - MFC seeing a SQLCODE = -312, when using the DB2 Caching Option.

Symptom

  • Turning the DB2 Caching Option to Yes in the MFC Configuration (screen print below) 
    causes certain queries to return DB2 -312 SQL Error code.
    The default setting is No.
  • Message:
    Msg 30000, Level 11, State 42:
    Procedure 'AMD2', Line 618:
    DB2 Access Module DBMS error (DB2 PREPARE failed:  DSNT408I SQLCODE = -312,
    ERROR:  VARIABLE *N IS NOT DEFINED OR NOT USABLE

amd2DB2Cache.png


Read more...

Environment

Mainframe connect DB2/UDB Option for CICS/IMS version 15 SP05 and SP06

Product

Sybase MainframeConnect 15.0

Keywords

MFC DB2 -312 , KBA , BC-SYB-MFC , Mainframe Connect (MFC) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.