Kbase P49806: 4GL/ABL: What is the maximum length of a Progress TEMP-TABLE or Database record?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/03/2011 |
|
Status: Verified
GOAL:
4GL/ABL: What is the maximum length of a Progress TEMP-TABLE or Database record?
GOAL:
Is the 32KB record size limit still effective in OpenEdge?
FACT(s) (Environment):
OpenEdge 10.x
All Supported Operating Systems
Progress/OpenEdge Product Family
FIX:
The maximum length of a Progress TEMP-TABLE or Database record is 32KB. This limit is still effective as of this writing (10.2B03). There are no plans to increase the 32KB record size limit in the foreseeable future. To store more than 32KB in a TEMP-TABLE, use CLOB or BLOB data type fields. When a BLOB (Binary Large Object) or a CLOB (Character Large Object) field is defined in a database table or a temp-table, the record stores only a pointer to the location where the BLOB/CLOB is actually stored.