Kbase P24783: Running UPDATE STATISTICS against a table generates error 9233
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/3/2009 |
|
Status: Verified
SYMPTOM(s):
Running UPDATE STATISTICS against the table
Table contains more than the maximum columns currently supported. (9233)
FACT(s) (Environment):
Progress 9.x
All Supported Operating Systems
OpenEdge 10.x
CAUSE:
Table actually has more than 500 fields defined within it (table was defined via the Data Dictionary rather than through SQL) and the SQL-92 engine has a documented limit of 500 fields per table
FIX:
Split the definition of the table into two or more tables