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
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.