Kbase P147817: TO-ROWID() function fails to convert strings longer than 512
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/06/2009 |
|
Status: Unverified
SYMPTOM(s):
TO-ROWID() function fails to convert strings longer than 512
A statement to find a record based on rowid fails
FACT(s) (Environment):
OpenEdge 10.x
IBM AS/400 (RISC)
ODBC DataServer
In case of ODBC DataServer connected to iSeries (AS/400) the ROWID is sometimes calculated to a value longer than 512 bytes.
CAUSE:
Bug# OE00185891
CAUSE:
Internal limit for TO-ROWID(string) function is 512.
FIX:
The only workaround at the moment is to reduce the number of columns in the composite key used for ROWID. A smaller unique key in the index set can be selected to replace the current ROWID. In addition, shorter column names of the component columns for ROWID will decrease its length