Re: RBSBIG

[Paul Hoyte <phoyte@SHARIDIONNE.COM>]

Sorry George.  Guess I did mis-understand the reply.  Comes from reading
too fast I guess.  Your solution is correct and you would have to set
the RBS for each transaction.

Paul Hoyte
Sharidionne Inc.
(248) 559-6868
Email: phoyte@sharidionne.com



-----Original Message-----
From: Discussion of SQR, Brio Software's database reporting language
[mailto:SQR-USERS@list.iex.net] On Behalf Of George Jansen
Sent: Wednesday, July 10, 2002 4:07 PM
To: SQR-USERS@list.iex.net
Subject: Re: RBSBIG


Paul,

What I was trying to illustrate was that

a. SET TRANSACTION USE ROLLBACK SEGMENT is effective within SQR b. It is
good for one transaction only: do  a commit (or rollback, or issue some
DDL), and the new transaction will probably bring a new rollback
segment.

Sorry if this wasn't clear. It doesn't have to be the same
begin-sql/end-sql paragraph; executing another procedure will affect it
only there's a commit or rollback (possibly implicit or auto).

George

>>> phoyte@SHARIDIONNE.COM 07/10/02 03:42PM >>>
George:

I would suggest executing the insert/update commands within the same
begin-sql paragraph or set the transaction to use the rbsbig EACH time
just before you execute the insert but within the same begin-sql
paragraph.  Transactions can be assigned different RBSegments so to hold
the one that you want you have to use it right away with the sql
paragraph.  Executing another procedure will create the possibility to
lose the assigned segment.

HTH

Paul Hoyte
Sharidionne Inc.
(248) 559-6868
Email: phoyte@sharidionne.com