Kbase P93265: Suggestion to change the marshalling of temp tables in OpenEdge
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.0A
SYMPTOM(s):
In OpenEdge 10.0A there are new attributes on the temp table handle to vary how much schema information is passed with the temp table
NO-SCHEMA-MARSHAL Attribute of temp-table handle (logical):
Set to true to omit all schema information when marshalling data for a large temp-table parameter. This suppresses index descriptions and all field information. The receiving procedure must have a static temp-table definition in which to receive the temp-table.
MIN-SCHEMA-MARSHAL Attribute of temp-table handle (logical):
Set to TRUE to minimize schema information when marshaling data for a temp-table parameter. This suppresses index descriptions and some field information (such as initial value, label, help, and so on).
Suggestion is to make this a startup parameter and to use just one attribute with multiple values rather than two logical attributes.
CAUSE:
Enhancement request# 20040901-001
FIX:
Upgrade to 10.0B01 or higher
New startup parameter added: -ttmarshal n
n = 1 means all static tables are min-schema-marshal
n = 2 means all dynamic and static tables are min-schema-marshal
n = 3 means all static tables are no-schema-marshal
n = 4 means all dynamic and static tables are no-schema-marshal
New SCHEMA-MARSHAL property added to the temp-table-handle
htt:SCHEMA-MARSHAL = char-expression
char-expression can be "MIN", "NONE" or "FULL" .
The SCHEMA-MARSHAL, NO-SCHEMA-MARSHAL and MIN-SCHEMA-MARSHAL properties
of a temp-table take precedence over the -ttmarshal startup option.