SAP Knowledge Base Article - Preview

2777600 - Error 226 occurs when using a multi-statement transactions in SAP Data Services 4.2 x

Symptom

When using ASE as the source Database and a multi-statement script with SELECT INTO from Data Services Desinger, the following error occurs.

@RUN-050304, ERROR, 0, 0.000, 1.406, 0.000, 0.000, 0:0, 0.000, 0, RUN-050304: |Session : Function call <sql ( <tablename>, select * into <tablename>.<database> from <tablename>.<Database> go ) > failed, due to error <70602>: <Sybase SQL Server <DD2> error message for operation <ct_results>: <Sybase Server message number <226> State <1> Severity <16> From Server <DD2>: Message Text is: SELECT INTO command not allowed within multi-statement transaction. >.>.


Read more...

Environment

  • WINDOWS 2016
  • Information Platform Services 4.2 SP5 PL7
  • SAP Data Services 4.2 SP10
  • ASE 

Product

SAP Adaptive Server Enterprise 16.0

Keywords

Error 226, DBS - 70602, RUN-050304 , KBA , EIM-DS-EXE , Job Execution , Problem

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.