[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: RBSBIG

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