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 for Me (Login required).

Search for additional results

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