SAP Knowledge Base Article - Preview

2895236 - Function String using T-SQL variable cause variable already declared error

Symptom

If we have defined Function-String using T-SQL variable in the "output language" clause and when several statement using same T-SQL variable are sent to target ASE, ASE error #134 is raised because of re-declaration of T-SQL variable :

=====

E. 2020/02/20 14:11:09. ERROR #1028 DSI EXEC(103(1) ASE_XXXX.rdb1) - dsiqmint.c(3221)
Message from server: Message: 134, State 1, Severity 15 -- 'The variable name '@v1o' has already been declared. Variable names must be unique within a query batch or stored procedure.

=====


Read more...

Environment

 SAP Replication Server (All Versions)

Product

SAP Replication Server 15.7 ; SAP Replication Server 16.0

Keywords

function string functionstring output language message error 134 declare variable has already been declared Variable names must be unique within a query batch or stored procedure CR 642966 CR642966 , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Product Enhancement

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.