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

Search for additional results

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