Kbase P6720: Description for TEMP-TABLE is too large for use in paramete
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/02/2003 |
|
Status: Unverified
SYMPTOM(s):
Description for TEMP-TABLE <table-name> is too large for use in parameter. (9070)
CHANGE:
Using temp-table as a parameter in a 4GL procedure.
CAUSE:
The maximum number of fields in a temp-table being used as a parameter is about 500, depending on how much data is involved in each string (length of name, initial value etc). The limit of the temp table description is 32K. Exceeding the overall limit or the number of fields limit will generate the above error.
FIX:
To resolve this issue:
1. Limit the number / Length of fields in the temp table. AND / OR
2. Limit the number / Length of the indexes defined for that temp table.
to acceptable limits.