2018484 - How to set up function (stored procedure) replication from ASE to DB2 z/OS - SRS | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2018484 - How to set up function (stored procedure) replication from ASE to DB2 z/OS - SRS

Symptom

  • SAP Replication Server (SRS)
  • Function (stored prcedure) replication was setup from Adaptive Server Enterprise (ASE) to IBM DB2 z/OS
  • The DSI to Mainframe Connect DirectConnect for z/OS suspended with the following error:

T. 2014/05/02 11:35:29. (95): Command(s) to 'MFC.db1':
T. 2014/05/02 11:35:29. (95): 'set TransactionMode long'
T. 2014/05/02 11:35:29. (95): Command(s) to 'MFC.db1':
T. 2014/05/02 11:35:29. (95): '{CALL SCHEMA.PROCNAME(@ColumnName)}'
E. 2014/05/02 11:35:29. ERROR #1028 DSI EXEC(107(1) MFC.db1) - dsiqmint.c(4272)
Message from server: Message: 30291, State 0, Severity 19 -- '[[Message Iteration=1|Data Source Name=MFCDB1|SQLState=37000|Native Error=-99999|Message=[IBM][CLI Driver] CLI0118E  Invalid SQL syntax. SQLSTATE=37000]'.

 


Read more...

Environment

  • SAP Replication Server (SRS) 15.6
  • Mainframe Connect DirectConnect for z/OS 15.0 ESD#3
  • DB2 mainframe OS version z/OS 01.13.00
  • DB2 version - z/OS DB2 10.1

Product

SAP Replication Server 15.7

Keywords

function, replication, DB2,  mainframe,  stored procedure , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-REP-HET , Replication Server Heterogeneous Edition (RSHE) , How To

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.