Re: SQR - Using ROLLBACK

["Kenny Melton (CORP)" <kenny.melton@CUMMINSUTILITY.COM>]

Chantelle,
    Check the SQR and ALL of it's associated #include files for any explicit
COMMIT statements being executed before the ROLLBACK is issued.  Especially
check any calls to procedures that update the process run status, I believe
several commits are executed there.

HTH,
Kenny

-----Original Message-----
From: Chantelle Wall [mailto:cwall@MAIL.RATH.PEACHNET.EDU]
Sent: Friday, May 04, 2001 08:49
To: SQR-USERS@list.iex.net
Subject: SQR - Using ROLLBACK


We are all stumped, could someone please offer some suggestions?

 I am running an SQR from a PS Panel and under certain conditions a
ROLLBACK and STOP command are executed.  And for some unknown reason the
affected tables are still being updated by this SQR.

Any suggestions would be appreciated!

Thanks!