Kbase P105316: Number of fields in a table is limited to 500 for DB2 database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
09/11/2010 |
|
Status: Unverified
SYMPTOM(s):
Number of fields in a table is limited to 500 for DB2 database
DB2 Wire Protocol driver version 5.00.00.102
It's impossible to migrate a table definition to ODBC schema when it contains more than 500 fields
WARNING: TABLE table_name will not be created.
Table has 506 columns including shadow columns and arrays. DB2 only supports 500.
FACT(s) (Environment):
IBM AS/400 (RISC)
ODBC DataServer
OpenEdge 10.x
CAUSE:
Bug# OE00116855
FIX:
Modify the table structure before migration so as the limit wouldn't be exceeded