Hi Noah and Elias, it should be possible to rename columns using the table def dialog.
could you provide the usual version strings (DB kernel, SQL Studio) and a table definition for reproducing the error ? Does this happen generally or only in special cases ? any hints appreciated, regards, Markus Stausberg SAP Labs Berlin > -----Original Message----- > From: Noah J SILVA [mailto:[EMAIL PROTECTED] > Sent: Monday, March 17, 2003 4:40 PM > To: Elias Martenson > Cc: [EMAIL PROTECTED] > Subject: Re: Modify Table Error > > > Hi, > > I was trying to do the rename from the SQL Studio "Alter > Table" dialog. > This was the only change I made. Strangely enough, though I couldn't > change the column's name, I was able to change it's type. > > I made a new column with the new name and did: > > update table > set new=old > > update table > set old = 0 > > This worked around the problem, but I feel a little > uncomfortable with > problems like this existing, so I still hope someone can > explain why this > happened and how to fix it. > > Thank you, > Noah Silva > IS&T - Programmer Analyst > (215) 419 - 7916 > > > > > > Elias Martenson <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 03/17/2003 10:30 AM > > > To: [EMAIL PROTECTED] > cc: > Subject: Re: Modify Table Error > > > Noah J SILVA wrote: > > Hi, > > > > I am running SAPDB 74[.0.14?] on windows 2000, the DB type > is OLTP. I > am > > accessing the DB in internal mode. > > > > I have a table, which contains a column like: > > > > NAME TYPE DEFAULT > > -------------- ---------------- ---- > > DEGREE SMALLINT 64 > > > > There are quite a few other columns, mainly Boolean and > integer, with a > > few short CHAR and VARCHAR. > > > > I tried to rename DEGREE to STRENGTH in SQL Studio, and > when I select > > execute, I get an error dialog: > > > > "Database Error Occurred: > > Native Error: -9406 > > Text: [SAP AG][SQLOD32.DLL][SAP DB]General Error; -9406 DDL Trigger > failed > > : 200." > > It's funny, I had the exact same problem this weekend. You > were trying > to execute the rname as part of a batch, didn't you? > > > _______________________________________________ > 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 > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
