Kbase P4230: ESQLC - Error syntax near statistics
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/03/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1C
SYMPTOM(s):
Error syntax near statistics
Running UPDATE STATISTICS from ESQLC application
<file name>.c:3181: `update' undeclared (first use in this function)
<file name>.c:3181: (Each undeclared identifier is reported only once
<file name>.c:3181: for each function it appears in.)
<file name>.c:3181: parse error before `statistics'
CAUSE:
Tthe UPDATE STATISTICS statement is not supported by ESQLC.
ESQLC does support "standard" SQL statements, but UPDATE STATISTICS is not
standard.
FIX:
Run UPDATE STATISTICS as dynamic sql:
strcpy(cSQL,"update statistics");
exec sql execute immediate :cSQL;