Kbase P122807: SQL-92 Error "Internal error -2" executing an UPDATE statement to modify an ARRAY field.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
29/06/2009 |
|
Status: Verified
SYMPTOM(s):
SQL: Error: Internal error -2 when UPDATE of a WORD indexed array field
Update count = 0.
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-219901
[DataDirect][OpenEdge JDBC Driver][OpenEdge] Internal error -2 (a column with the specified column id does not exist in the row) in SQL from subsystem RECORD SERVICES function rec_to_data called from stub_tpl_hdl_t::extract_fields on PUB.TableName for ArrayFieldName. Save log for Progress technical s
Executing a statement similar to the following:
UPDATE
PUB.TableName
SET
ArrayFieldName = '1 Main Street;;';
Where ArrayFieldName is a CHARACTER array field with three extents.
CAUSE:
The array field is indexed. That is one or more indexes are defined using the ArrayFieldName.
FIX:
Array columns and element references cannot be indexed. Delete any indexes that reference the array field.