Kbase P72709: Error 2075 When Using Global Shared Temp-Tables LIKE another TT
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/3/2011 |
|
Status: Unverified
SYMPTOM(s):
Error 2075 When Using Global Shared Temp-Tables
Error 2075: In procedure <procedure>, shared temp-table <table-name> has a conflict in field, index or undo status. (2075)
The original temp-table was defined LIKE another temp-table.
CAUSE:
Bug# OE00102097
FIX:
Define the Temp-table using a separate LIKE definition for each field. So instead of:
DEFINE NEW SHARED TEMP-TABLE temp2 NO-UNDO LIKE temp .
You use:
DEFINE NEW SHARED TEMP-TABLE temp2 NO-UNDO
FIELD DUMMY1 LIKE temp.dummy1
FIELD DUMMY2 LIKE temp.dummy2
INDEX DUMMY DUMMY1 DUMMY2 ASCENDING.