Temp-table buffers
- Last Updated: April 4, 2024
- 1 minute read
- OpenEdge
- Version 13.0
- Documentation
When you reference a database table in an ABL procedure, ABL provides you with
a default buffer with the same name as the table. In this way, when you write a statement,
such as FIND FIRST Customer, you are actually referring to a
buffer with the name Customer. You can, of course,
define additional buffers explicitly that have different names from the database table.
The same is true of temp-tables. When you define a temp-table,
ABL provides you with a default buffer of the same name. Just as
for database tables, you can define additional buffers with other
names if you like. When you refer to the temp-table name in a statement
such as FIND FIRST ttCust, you are referring to
the default buffer for the temp-table just as you would be for a
database table.
There is a temp-table attribute, DEFAULT-BUFFER-HANDLE,
that returns the handle of the default buffer.
-tmpbsize) startup parameter. For example, specifying
-tmpbsize 1 would create temp-tables with a 1KB block size. For more
information about the Temporary Table Database Block Size startup parameter, see Startup Command and Parameter Reference.