March 3, 2009 at 10:14 am
When I was developing on DB2 m/f all I used was BEGIN TRANSACTION and END TRANSACTION...
...I sometimes used to add some SQL in the middle...
and I just remembered that DB2 requires you to end all statements with a semi-colon. The ; is optional in SQL Server but mandatory on DB2. There is a connection string option that allows you to use a different character to the ; but I have no idea what it is.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
March 3, 2009 at 10:35 pm
BEGIN TRANSACTION /END TRANSACTION doesnot work ib my DB2 OS390 7.1.1. May be in some other version.....i am stuck such simple piece is required and i cannot find it out 🙁
Thanks
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply