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 ONE Support launchpad (Login required).

Search for additional results

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