SAP Sybase

Error 226 'xxx' command not allowed within multi-statement transaction

Error 226 ‘xxx’ command not allowed within multi-statement transaction

In the earlier post Error 2762 The ‘xxx’ command is not allowed within a multi-statement transaction in the database, we covered how to find a work-around for solving multi-statement transaction error and keep it running while having option of rolling back or committing it based on the requirement and execution. Today, we will talk about …

Error 226 ‘xxx’ command not allowed within multi-statement transaction Read More »

SAP Sybase ASE - How to Add Server Entry in Interfaces File Through DSCP

SAP Sybase ASE – How to Add Server Entry in Interfaces File Through DSCP

As you know interface file holds details of servers where Sybase ASE can connect to, here we are talking about server level, we shall cover details about client side in different post. A typical interface file contains server name(could be anything as per your choice), IP or hostname of the server and port number, which …

SAP Sybase ASE – How to Add Server Entry in Interfaces File Through DSCP Read More »

Error 2762 The 'xxx' command is not allowed within a multi-statement transaction in the database

Error 2762 The ‘xxx’ command is not allowed within a multi-statement transaction in the database

While deploying the code from development team or support team or vendor provided code, you would have encountered below error and would have thought why this message and why to perform DDL statement inside a user transaction: The ‘%s’ command is not allowed within a multi-statement transaction in the ‘%.*s’ database. Lets understand why this …

Error 2762 The ‘xxx’ command is not allowed within a multi-statement transaction in the database Read More »