Re: RBSBIG

[Jennifer Tran <jtran@BMS.CALSTATE.EDU>]

You might also want to specify the rollback segment to be used by the 
operator(s) (either it is a person, a session or a specific process) while 
running the SQR job. This needs to be done
by the DBA within oracle, in constrast to the SET TRANSACTION...command issued 
within the SQR itself. By defaulting the rollback segment to be used in the 
oracle environment, when the
operator runs the SQR, the specified rollback segment must be used.  Also, you 
might want to use COMMIT statement to assist in using the rollback segment. 
HTH..


Ken Boettger wrote:

> 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

--
*********************************
California State University
       -----------
        Jennifer Tran
Email: jtran@bms.calstate.edu
Phone: (562)951-4395

 Making everyday a better day
*********************************