Kbase P120869: Insert operation fails when PROGRESS_RECID field is not hidden
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/5/2006 |
|
Status: Unverified
FACT(s) (Environment):
IBM AS/400 (RISC)
OpenEdge 10.1x
ODBC DataServer
SYMPTOM(s):
Insert operation fails when PROGRESS_RECID field is not hidden
[DataDirect][ODBC DB2 Wire Protocol driver]Invalid cursor state.
PROGRESS_RECID field is included in every insert statement
CAUSE:
This is a known issue being investigated by Development
FIX:
At the moment the only workaround is to hide PROGRESS_RECID field manually in the schema holder:
1. Dump the schema holder definition of the problematic table(s) to a df file
2. Modify the HIDDEN-FLDS option in the ADD TABLE section so as it would contain the PROGRESS_RECID field, for example:
ADD TABLE "MyTable" TYPE ODBC
AREA "Schema Area"
DUMP-NAME "MYTABLE"
FOREIGN-NAME "MYTABLE"
FOREIGN-OWNER "COLLECTION"
FOREIGN-TYPE "TABLE"
PROGRESS-RECID 33
INDEX-FREE-FLD 13
HIDDEN-FLDS "34,33,"
RECID-FLD-NAME "PROGRESS_RECID"
3. Delete the old table definition from the schema holder
4. Load a new df file with suggested changes
Alternatively, if many tables are affected, the whole schema holder can be recreated and loaded with proper table definitions.