Some SQR programs require a
larger rollback segment than others.  When an SQR transacton runs it pick
the first available Rollback segment that Oracle gives.  This sometimes can
cause your SQR to fail with an Oracle error

"Unable to extend Rollback Segment"



The following code bit can be placed in an SQC and called from your
SQR.  This will force the SQR to use a specific Rollback Segment.  You
can force the transact to use the Large rollback segment instead of the smaller
ones.

!
--------------------

! - BEGIN CODE BIT

! --------------------



begin-procedure get-large-rollback

begin-sql

   SET TRANSACTION USE ROLLBACK SEGMENT FSPDRBK5

end-sql

end-procedure get-large-rollback



! --------------------

! - END CODE BIT

! --------------------