Kbase P59790: ASCII export from Data Dictionary on UNIX returns syntax error for WHERE-clause
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
06/04/2004 |
|
Status: Unverified
FACT(s) (Environment):
Progress 7.3E
SYMPTOM(s):
ASCII export from Data Dictionary on UNIX returns syntax error for WHERE-clause
The syntax entered for WHERE and/or BY is invalid.
WHERE-clause is specified
CAUSE:
In Progress v7 it is possible to export to an ASCII file from the Data Dictionary on UNIX. A WHERE-clause can be specified to limit the dumped data. If the WHERE keyword is left out from this WHERE-clause, for example, the syntax error occurs.
FIX:
Check your syntax in the WHERE-clause, e.g. ensure that you are writing
WHERE cust-num < 30
rather than just
cust-num < 30
In the working directory for the database, a nnnn.adm file will be created (nnnn stands for the PID). This file contains the 4GL code that is generated using the input from the fields you have filled in under the Data Dictionary. It should be clear from this file in exactly what way the syntax is incorrect, e.g. the WHERE might simply be missing.