Kbase P8544: Why [MERANT][ODBC PROGRESS driver] error (247) and (254)?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
FACT(s) (Environment):
MERANT 3.60 32-BIT Progress SQL-89
MERANT 3.70 32-BIT Progress SQL-89
MERANT 4.0 32-BIT Progress SQL-89
SYMPTOM(s):
Error querying database tables via SQL-89
[MERANT][ODBC PROGRESS driver][PROGRESS]** Unable to understand after -- "DECLARE". (247)
[MERANT][ODBC PROGRESS driver][PROGRESS]** Invalid statement. (254)
Query using SQL Column aliasing option.
CAUSE:
Progress SQL-89 does not support the SQL Column (field) aliasing option. The following is an example.
SELECT pub.customer.name AS myAlias FROM Customer WHERE pub.customer.name > '';
FIX:
Upgrade to Version 9.x and use SQL-92 where the Column Aliasing feature is supported.
It should be noted SQL-92 support is not available with certain releases/ports, such as those for SCO OpenServer, SUN Solaris Intel, and DG-UX. Please see your release notes for further details.