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
