Re: RollBack in SQL Server

["Kloprogge, F.J.M. (Frank)" <F.J.M.Kloprogge@FONTYS.NL>]

Hi Hugo,

You can try the next:

Begin-procedure my-rollback
Begin-sql
        Rollback
End-sql
End-procedure

And call this procedure.

This is actually what the Rollback-Transaction procedure does.


Frank Kloprogge
Fontys ICT-services
DBA / AP PeopleSoft
08778-78710


 -----Oorspronkelijk bericht-----
Van:    Hugo Dionisio Venturini [mailto:hventurini@BANCORIO.COM.AR]
Verzonden:      donderdag 28 september 2000 18:21
Aan:    SQR-USERS@LIST.IEX.NET
Onderwerp:      RollBack in SQL Server

I am working with the following configuration in my company:

PeopleSoft HRMS Version 7 - PeopleTools 7.03
SQRW Version: 3.0.16.4
Platform: Windows NT 4.0 S.P.3
Database: SQL Server 6.5

I want to programme a Rollback sentence in a SQR so I read the SQR Book
Guide and I found that the Rollback command can be used with Oracle,
SQLBase and Ingres. It doesn't mention if this apply for Microsoft SQL
Server.

So I found in some SQRs, programmed two years ago by a consultant
company, that they used the following procedure when they an error
appears:
do Rollback-Transaction

I am not sure if this procedure could function correctly.

I want to use a sentence like this (it is showed in the guide):
if error...
   rollback
   stop
end-if

Could I replace the "rollback" sentence with "do Rollback-Transaction" ?

Thank you very much for helping me.

--
Hugo D. Venturini
Sistemas de RRHH
Banco Rio de la Plata S.A.
TE: 0054-11-4341-1000
Interno: 4053 / 52 / 49