Salesforce

Does any data of a NO-UNDO WORK-TABLE get stored on in the BI file or anywhere outside the RAM memory?

« Go Back

Information

 
TitleDoes any data of a NO-UNDO WORK-TABLE get stored on in the BI file or anywhere outside the RAM memory?
URL NameP192023
Article Number000157556
EnvironmentAll Supported Operating Systems
Progress 9.x
OpenEdge 10.x
Question/Problem Description
4GL/ABL: Does the data of a NO-UNDO WORK-TABLE ever get stored in the BI file or anywhere outside the RAM memory?
Are there cases where the data of a NO-UNDO WORK-TABLE is stored on disk?  If yes, when and where?
Steps to Reproduce
Clarifying Information
Error Message
Defect Number
Enhancement Number
Cause
Resolution
WORK-TABLES (as opposed to TEMP-TABLES) do not "live" stored on disk.  If a WORK-TABLE  or a PROGRAM VARIABLE is UNDO, the data can end up in the LBI file (never the BI).  But if it is NO-UNDO, it is not written to a before-image file.


If the NO-UNDO WORK-TABLE has a large amount of data and that data is sorted or preselected or queried in a manner that generates a result list, then that data ends up in the SRT file.

Please note:
  1. Progress uses the Local Before Image (LBI) to back out of sub transactions and variable value changes.
  2. Large in this context is relative to the amount of memory available for the client process (the local buffer size –l), the amount of data in the work table, the amount of data in the local buffer occupied by other variables and records and the amount and complexity of sorting involved.
Workaround
Notes
Keyword Phrase
Last Modified Date9/13/2015 11:42 PM

Powered by