Re: RBSBIG

[Ken Boettger <BoettgeK@CWU.EDU>]

Thanks Paul.

I will need to play with the privs in our test environment.  I think one of our 
people here tried this but it still used the default segment. So the privs may 
be the issue here. Thanks.

-Ken

>>> phoyte@SHARIDIONNE.COM 07/09/02 01:34PM >>>
Ken:

If you have the correct privileges to issue the command, this can be
done by executing a sql statement as part of the begin-sql paragraph.
The command will set the current transaction to use which ever rollback
segment that you specify in the command...

begin-procedure test_rbs

begin-sql

    SET TRANSACTION USE ROLLBACK SEGMENT rbs3;



    insert into dept values(9888, 'TEST DEPT', 'BRIGHTON');

end-sql

end-procedure



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 Ken Boettger
Sent: Friday, July 05, 2002 7:50 PM
To: SQR-USERS@list.iex.net
Subject: RBSBIG


I am looking for information on RBSBIG. I would like to allocate a
larger sector programmatically during the execution of an SQR report
(something we run in batch every evening).  Can this be done with SQR
code?

-KenB