Re: Table aliases on a DELETE statement

Jacob Salomon wrote: } } 4GL 6.01.UD2 } DSA 7.11.UC1 } } Hi family. } } When I do a typical SELECT statement, I almost always use table aliases. } For example: } select y.col1, u.col2, t.col3, z.col4 } from table_one y, table_two u, table_three t, table_four z } where <whatever joins & conditions are appropriate> } } In an application, I am preparing a DELETE statement very much like } this: } delete from gpprgtab t where t.modname = "X" and t.progname = "Y" } } I get a 201 syntax error message: } delete from gpprgtab t where t.modname = "X" and t.progname = "Y" } # ^ } # 201: A syntax error has occurred. } } When I stop using table aliases, the error goes away. No big deal, of } course, since [under Informix] I can delete from only one table in a } single statement anyway. But is such a restiction normal? Is it } documented? (I am looking through the "Guide to SQL" as I write this.) } } I will hold off removing the table aliases from the UPDATE statements } until my debugging process gets up to there also but I suspect I will } have to remove those aliases; the same reasoning applies. } } A bit annoying! } } Comments? } -- } -- Jake (Engaged in the persuit of undomesticated aquatic avians) } +-----------------------------------------------------------+ } | Impeccable Logic: A thought process which successfully | } | resists chicken bites | } +-----------------------------------------------------------+ Hi Jake, in the "Informix Guide to SQL:Syntax" says that it is only allowed in the FROM Clause of a DELETE Statement to use a table, view or synonym name. Some for the UPDATE statement. Regards Tolis -- +---------------------------------------------------------------------+ | V+K Relational Solutions email: tvarnas@compulink.gr | | Deligiorgi 26 tvarnas@orbit.de | | 546 42 Thessaloniki Voice: (30) 31 820270 | | Greece Fax: (30) 31 865463 | +---------------------------------------------------------------------+