Kbase P7266: SQL92 doesn't share 4GL functions where SQL89 does.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/27/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1x
SYMPTOM(s):
Can't use BEGIN statement with SQL92
SQL89 based programs could use BEGIN
Has to use Like%
Getting SQL92 syntax error.
Syntax error (7587)
CHANGE:
Migrating programs from SQL89 to SQL92.
CAUSE:
SQL92 uses an engine which does not share any 4GL functions. It uses SQL standards. SQL89 and the 4GL share a number of functions. BEGINS is a 4GL function that allows for string comparison. In SQL92, BEGIN is used to call or launch a Stored Procedure or Trigger.
FIX:
Recode SQL programs to use the LIKE Function for SQL92.