Hello Thomas > It's clear, that all views built on the table are rebuild > implicitly.
That's what I thought, too: how can it produce *this* errormessage. We'll try to find out which querypart in which view causes the problem. Regards, G. Matter "Anhaus, Thomas" schrieb: > > Hi, > could you please give me some more details about the problem ? > It's clear, that all views built on the table are rebuild > implicitly. This may fail, if a view with a column list > and 'select *' exists. > But I can't imagine how this results in 'missing keyword FROM'. > > Regards, > Thomas > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Mittwoch, 5. Februar 2003 15:31 > To: [EMAIL PROTECTED] > Subject: Re: Alter Table Statement: -5015 Pos(241) Missing keyword:FROM > > ... > > We've found out that the problems came from VIEWdefinitions. > > => Our conclusion: > > 1. The output of the errormessage could be improved (this is possibly a > difficult task and we do not expect that a change will be done [soon]). > > 2. Thus it's important to always consider viewdefinitions when ALTERing > baseTABLEs: the errormessage could be misleading. > > G. Matter > Invoca Systems > > [EMAIL PROTECTED] schrieb: > > > > Hello > > > > This statement > > > > alter table artikel add a char(1) > > > > as well as other 'usual' alter table statements produce the following > > error message (not with all tables but with several): > > > > -5015 Pos(241) Missing keyword:FROM > > > > It seems that something within the catalog is wrong and causes this > > error. The checks all passed correctly. > > > > Has anyone an idea what exactly could cause that. > > > > (We use SAPDB 7.3.0, Build 030-000-088-166) > > > > Vtrace: > > > > ... ... > <cut> > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
